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