Multiple IF formulas

[sriddle]

Can I put more than on IF formula in a cell?

 

[JE McGimpsey]

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))

 

[Sheeloo]

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) ...

 

[Pete_UK]

Yes, here's one example with 3 IFs:

=IF(A1="","blank",IF(A1<0,"negative",IF(A1>0,"positive","zero")))

Hope this helps.

Pete