Check if row is 0 or blank

[onroute]

Hi all,

I have a number of rows that contains data (normally numeric):

0 | 0 | 0 | 0 | ... |True
1 | 0 | 0 | 0 | ... |False
0 | 1 | 0 | 1 | ... |False

What's the formula that gives the True/False answers?
I could go IF(AND(A1=0,B1=0,etc...),TRUE,FALSE) that gets the results, but can it be done in a smarter method or can it done via array method?

Cheers

[Tony Valko]

Maybe this array formula**:

=AND(A1:D1=0)

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

[FDibbins]

or
=COUNTIF(A1:D1,">0")=0

Not as simple/clean as Tony's, but *maybe* easier to understand?

[onroute]

Cheers guys!

[Tony Valko]

You're welcome!