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. |
#2
|
|||
|
|||
Quote:
Rookie mistake! |
#3
|
|||
|
|||
With only the three possible values, you could have shortened the formula to...
=IF(H2="PM01","Emergency Works",IF(H2="PM02","Routine Works","Pre Planned Maintenance")) :) |
#4
|
|||
|
|||
Quote:
Now I do. Cheers |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What's wrong with this IF?
On 26/07/2012 9:01 PM, Jay07 wrote:
=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. Hi Try this =IF(H2="","",IF(H2="PM01","Emergency Works",IF(H2="PM02","Routine Works","Pre Planned Maintenance"))) This takes into account a 4th condition being that H2 is blank. HTH Mick. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What's wrong with this IF?
On 27/07/2012 12:51 AM, Vacuum Sealed wrote:
=IF(H2="","",IF(H2="PM01","Emergency Works",IF(H2="PM02","Routine Works","Pre Planned Maintenance"))) Erata. Try this instead as the previous left the 3rd condition open and allowed for any value to be entered for it... =IF(H2="PM01","Emergency Works",IF(H2="PM02","Routine Works",IF(H2="PM03","Pre Planned Maintenance",""))) Cheers Mick. |
Reply |
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 |