  asked on

# IF statments in Excel 2007 (nested?)

Hello,
How can I do the following?

If A1 = 1, then "A" or If A1 = 2, then "B" or if A1 = 3, then "C"

I want to copy the formula down column B.  How can I put multiple values and multiple outcomes in an IF statement?

Thanks,
JE Last Comment
zorvek (Kevin Jones)

8/22/2022 - Mon
zorvek (Kevin Jones)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
zorvek (Kevin Jones)

You can also use CHOOSE:

=CHOOSE(A1,"A","B","C")

Kevin
justearth

Thanks.
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

two other possibilities without IF

=CHOOSE(A1,"A","B","C")  -- works only if the value in A1 really is 1 or 2 or 3

=LOOKUP(A1,{1,2,3},{"A","B","C"})  -- works whith whatever value is in A1, as long as these are listed in ascending order in the bold part of the formula.

cheers, teylyn
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

... slow phat phingers
zorvek (Kevin Jones)

=VLOOKUP(A1, {1,"A";2,"B";3,"C"}, 2, FALSE)

:-)