Avatar of justearth
justearth
Flag for United States of America 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
Microsoft ExcelSpreadsheets

Avatar of undefined
Last Comment
zorvek (Kevin Jones)

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
zorvek (Kevin Jones)

You can also use CHOOSE:

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

Kevin
justearth

ASKER
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
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Ingeborg Hawighorst (Microsoft MVP / EE MVE)

... slow phat phingers
zorvek (Kevin Jones)

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

:-)