In excel...

BHeemsoth

Platinum Member
Jul 30, 2002
2,738
0
76
How can I do an IF statement with multiple "if's" and multiple results of those ifs in the same cell.

I know you can do it using multiple cells, but how in one cell?

For instance if a1 = b,b1=2, if a1=c,b1=2, etc.

I am lost......
 

TwiceOver

Lifer
Dec 20, 2002
13,544
44
91
Nested IF. If x1=XX then IF or else IF

Basically just add an IF statement in your "Then" or "Else". I believe you have to type this all out though since the wizard is stupid.
 

Cattlegod

Diamond Member
May 22, 2001
8,687
1
0
i don't think you have to resort to VBA.

=IF(condition,IF(condition,IF(condition,Result1,Result2),result3),result4)

see if that works
 

kranky

Elite Member
Oct 9, 1999
21,019
156
106
This formula looks to see if the value in A4 is either 1, 2 or 3, and the result is that value or else (if A4 doesn't contain either 1, 2 or 3) the result is 0.

=IF(A4=1,1,IF(A4=2,2,IF(A4=3,3,0)))