Excel 2007 : If Statement

[george45]

I need an if statement that can handle 3 variables.

Example:
If A1="X" then 1
If A1="Y" then 2
If A1="Z" then 3

With standard if then I can only 2 outcomes.

[TMS]

=IF(A1="X,1,IF(A1="Y",2,IF(A1="Z",3,4)))


Regards

[NBVC]

=MATCH(A1,{"X","Y","Z"},0)

the X,Y,Z options are in order of what should correspond to 1,2,3.

or assuming those are three only choices.

=IF(A1="X",1,IF(A1="Y",2,3))