Identifying records with Zero in the data section

[sumitk]

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

[VBA Noob]

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

[sumitk]

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