shorten so many if statements

[wannabe12]

Hi there, in cell E6 I have this formula -

=IF(F6=0,(IF(G6=0,(IF(H6=0,(<wbr>IF(I6=0,(IF(J6=0,(IF(K6=0,(IF(L6=0,(IF(M6=0,(IF(N6=0,(IF(O6=0,(IF(P6=0,(IF(Q6=0,(IF(R6=0,(IF(S6=0,(IF(T6=0,(IF(U6=0,(IF(V6=0,(IF(W6=0,"1","0")),"0")),"0")),"0")),"0")),"0")),"0")),"0")),"0")),"0")),"0")),"0")),"0")),"0")),"0")),"0")),"0")),"0")
<wbr><wbr><wbr><wbr><wbr><wbr><wbr><wbr>

Basically evaluating if a cell is zero and if it is move on to the next cell, and then ***** again.
If all cells equal 0 display 1 otherwise display 0.

There are formulas in these cells so ISBLANK doesnt work.

Im sure theres a much simpler formula that can be used instead.

Any questions just email back.

Merry Christmas (yeah I know its early.lol)

Amish

 

[joms101]

Thank you Sir,

I used the formula you suggest. At first the cells appeared in #VALUE? But when I placed CTRL+SHIFT+ENTER into the formula, it works!

Once more, thanks for the help! I appreciate it.