I have an Excel Spreadsheet. I need help with if/then formulas?

Question

I have a spreadsheet with phone numbers. When someone calls my 800# I want to know what number they pressed. I have a column with the numbers 1-4 in each row.

1=sales 2=accounting 3=web 4=support, abandoned=abandoned.

If there a way to have the if statement return text?

Answer 1

=IF(A1=1, "SALES", IF(A1=2, "ACCOUNTING", IF(A1=3, "WEB", IF(A1=4, "SUPPORT", "ABANDONDED"))))

assuming A1 is the cell that contains the value of what the user pressed

--------------more----------->>>>

instead of hardcoding the results (WEB, SUPPORT, etc) you could just use a cell reference of where those results exist

in other words if your potential responses (web, support, etc) are in B1, C1, D1, E1 & F1

change the formula to:

=IF(A1=1, B1, IF(A1=2, C1, IF(A1=3, D1, IF(A1=4, E1, F1))))

now whatever is in those cells will appear as the result of the IF stmt.

Answer 2

You might use the Choose function:

assume your number (1 thru x) is in cell B2, then in cell C2, enter:

=CHOOSE(B2,"Sales","Accounting","Web",... "Abandoned")

Good luck!