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 if
all values = 0/

This array should work

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

use ctrl + shift + enter to use the array

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561253

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

Regards,
SK

"VBA Noob" wrote:


Hi,

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

This array should work

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

use ctrl + shift + enter to use the array

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561253