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
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