| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What's wrong with this IF?
=IF(H2="PM01","Emergency Works",IF(H2="PM02","Routine Works",IF(H2=PM03,"Pre Planned Maintenance")))
Column H can only contain either of PM01, PM02 or PM03. I want Column I to show the above values for each option. It works for both PM01 & PM02 but I'm just getting #NAME? for PM03. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What do I do wrong [Excuses pushing the wrong key combination earlier] | Excel Programming | |||
| What is wrong? | Excel Discussion (Misc queries) | |||
| Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
| What is wrong with this | Excel Discussion (Misc queries) | |||
| What's Wrong with This? | Excel Programming | |||
Threaded Mode
