| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Statement to display 3 different outputs instead of 2
I am trying to use an if statement to get 1 of a possible 3 inputs and then
display in a more human friendly manner, for example. The 3 inputs a p n o If someone types in p then I would like to have Passed displayed, f should display failed and o should display other. It works great if there are just 2 options but I cannot seem to find a solution for 3 variables. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statement that outputs specific text if cell is not null | Excel Discussion (Misc queries) | |||
| =+SUM(S2:S36) outputs 19190fault | Excel Worksheet Functions | |||
| How do you display IF statement results in a different cell | Excel Worksheet Functions | |||
| How do you display IF statement results in a different cell | Excel Worksheet Functions | |||
| conditinal If statement with 3 outputs | Excel Worksheet Functions | |||
Threaded Mode
