justearth
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.
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
=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
... slow phat phingers
=VLOOKUP(A1, {1,"A";2,"B";3,"C"}, 2, FALSE)
:-)
:-)
=CHOOSE(A1,"A","B","C")
Kevin