LinkBack URL
About LinkBacks
I want to plug true , if range E3:CW3 , have all 0
I want to plug true , if range E3:CW3 , have all 0
By All zeroes, I assume you mean each cell has a zero in it.
Do you want False if it doesn't
=COUNTIF(E3:CW3,0)=97
If you don't want the false
=IF(COUNTIF(E3:CW3, 0)= 97, TRUE, "")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Okay thank you , hearing 97 for the first time in my life
Assuming no empty cells...
This array formula**:
=AND(E3:CW3=0)
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
If you won't know for sure how many cells are in the range...
=COUNTIF(E3:CW3,0)=COLUMNS(E3:CW3)
E3:CW3 is a total of 97 cells
=COLUMNS(E3:CW3)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks