Identifying records with Zero in the data section

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all. I have a spreadsheet with one col. for a name (Col. A). Columns B - G
contain various values. Is there any way to put a formula in Col. H which
will tag Yes or No whether all the values in Col. B - G are zero? Please note
that I cannot add col. B - G since there might a positive value in col. B and
a negative col. with the same amount in col. C. In this case I would like to
tag this record as Non-Zero.

I considered a nested If-Then statement but it seems to be not the the most
efficient way to do it.

Thanks in advance for any suggestions.

Regards,
sk
 
Hi,

Think I understood your request. You just want it to say Yes or No i
all values = 0/

This array should work

=IF(AND(B2:G2=0),"Yes","No")

use ctrl + shift + enter to use the array

VBA Noo
 
Yes, you understood my request correctly and this worked like a charm. Thanks
a ton.

Regards,
SK
 
Back
Top