Help with a complex IF Formula

[irfananeeza]

Folks,

I have created the following IF formula. Wondering, if there is a way to rewrite the same IF formula in a shorter way or anyother short formula that can accomplish the same task. The reason I am asking I still have to add 6 more conditions in the same manner in this formula. Which If I add will make the formula way tooo long and tedious. I, even, wonder if I can add so many if conditions. Anyway, I just want to brief this formula.
Thanks to everyone in advance.

=IF(W1=0,"balance is zero",IF(AND(W1>0,G1<0),W1/G1,IF(AND(W1>0,J1<0),W1/J1,IF(AND(W1>0,M1<0),W1/M1,IF(AND(W1>0,N1<0),W1/N1,IF(AND(W1>0,O1<0),W1/O1,IF(AND(W1>0,P1<0),W1/P1,"Question")))))))

 

[lenze]

Assuming W1 will never be < 0, your AND statements are not needed

=IF(W1=0,"balance is zero",IF(G1<0,W1/G1,IF(J1<0,W1/J1,IF(M1<0,W1/M1,IF(N1<0),W1/N1,IF(O1<0,W1/O1,IF(P1<0),W1/P1,"Question")))))))

As far as more IF's, unless you have Excel 2007, you are limited to 7 Nested IFs. However, there are some workarounds. See Chip Pearson's Topic Index here
www.cpearson.com

lenze