In excel...

[BHeemsoth]

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

 

[Turkish]

VBA?

 

[Kenny1234]

Visual basic would do the trick

 

[Cattlegod]

use AND()

 

[TwiceOver]

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.

 

[Twista]

Originally posted by: Kenny1234
Visual basic would do the trick

 

[Nikamichi]

Originally posted by: Kenny1234
Visual basic would do the trick

 

[BHeemsoth]

Originally posted by: Nikamichi

Originally posted by: Kenny1234
Visual basic would do the trick

has to be done solely within excel...

 

[Cattlegod]

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]

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

 

[Turkish]

Originally posted by: rpbri2886

Originally posted by: Nikamichi

Originally posted by: Kenny1234
Visual basic would do the trick

has to be done solely within excel...

You can use VBA within Excel.

Click View > Toolbars > Visual Basic

Hit Visual Basic Editor.

 

[Yossarian]

you can do it in excel but it will be hard to read and debug. vba is much cleaner.