troubleshooting Question

IF statments in Excel 2007 (nested?)

Avatar of justearth
justearthFlag for United States of America asked on
Microsoft ExcelSpreadsheets
6 Comments1 Solution256 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros