An if statement for more than two possibilities

[percivaltroy]

When writing an if statement for 2 options "2-0" or "2-1" as answers you can write =IF(A1"2-0",B1,C1) which returns B1 if A is 2-0 otherwise it returns C1 reading.
So A1 will either be 2-0 or 2-1 and B1 and C1 have readings like 2.35 and 3 so if A1 was 2-0 and in B1 was 2.35 then it would read 2.35.... etc

How do i write it if A1 can equal 3 different things for example A1 can be 3-0 or 3-1 or 3-2.

Do i need to post an example or can someone relate to what im trying to achieve?

[zbor]

that would be nice

Generaly you do this:

=IF(A1=statement1; B1; IF(A1=statement2; B2; IF(A1=statement3; B3; C1))) etc

[percivaltroy]

thnx that was fine