Can I put more than on IF formula in a cell?
J JE McGimpsey Dec 10, 2008 #2 Yes, there are several ways to do that. What are you really trying to do? One way: =IF(<condition1>,1, 2) + IF(<condition2>, 3, 4) another: =IF(<condition1, 1, IF(<condition2>, 2, 3))
Yes, there are several ways to do that. What are you really trying to do? One way: =IF(<condition1>,1, 2) + IF(<condition2>, 3, 4) another: =IF(<condition1, 1, IF(<condition2>, 2, 3))
S Sheeloo Dec 10, 2008 #3 Yes. I think you can nest upto seven IFs in a formula. =IF(cond1,IF(cond2,do_true_2,do_false_2),do_false_1) ...
Yes. I think you can nest upto seven IFs in a formula. =IF(cond1,IF(cond2,do_true_2,do_false_2),do_false_1) ...
P Pete_UK Dec 10, 2008 #4 Yes, here's one example with 3 IFs: =IF(A1="","blank",IF(A1<0,"negative",IF(A1>0,"positive","zero"))) Hope this helps. Pete
Yes, here's one example with 3 IFs: =IF(A1="","blank",IF(A1<0,"negative",IF(A1>0,"positive","zero"))) Hope this helps. Pete
