Identifying records with Zero in the data section
 

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

Identifying records with Zero in the data section
 

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

Identifying records with Zero in the data section
 

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