Multiple IF statements in one formula?

[litestream]

Can I have more than one "IF" statement in a formula?

For example:

If x=1 is true, then y, if not z
If x=2 is true, then v, if not w
If x=3 is true, then t, if not u

How would I put this in a formula?
Would it be better to use some VBA coding rather than a long formula?

 

[Stormseed]

Can I have more than one "IF" statement in a formula?

You can have 7 nested IF formulae in Excel....moreover writing a vba code wont allow you flexibility in modifying your work -everytime u need to perform a change in the formulae -you will need to edit the macros :wink:

 

[SlinkRN]

On the other hand, formulas generally take longer to run and wouldn't you have to edit your formulas too every time you make a change? I would rather edit a macro than a formula but that's just my opinion. Formulas do some amazing things too. To each his/her own Slink

 

[MidNiteRaver]

Interesting replies but they seem to have not provided the "how do I do it".

Basically once you start an IF Function Arguements, and have stated your "logical_test" you can add additional IF functions in the "Value if true and value if false", simply "click" on the IF function from the toolbar to insert additional IF functions.

Short but I hope this helps.

 

[Brian from Maui]

Can I have more than one "IF" statement in a formula?

For example:

If x=1 is true, then y, if not z
If x=2 is true, then v, if not w
If x=3 is true, then t, if not u

How would I put this in a formula?
Would it be better to use some VBA coding rather than a long formula?

If it's not 1,2 or 3, which is it, z, w, or u?

 

[cheveley]

the "if not" part of your logic does not make sense to me, it can only be one thing, not three.

correcting for the above-mentioned, your formula should look something like:

=if(x=1,"y",if(x=2,"v",if(x=3,"t","")))

this formula will return a blank if 1,2,3 is not found. this can be changed.