| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If Statements - Need Help
I am getting so confused by these If Statements!! I have 3 columns
that I need to encorporate into my If Statement. I need it to say: If column J = the letter "M", then put "REPAIR", IF column H = 0, then put "REPAIR", IF column I < 0, "REPAIR", "DO NOT REPAIR" Does this make any sense?? It does in my head, but not sure if I typed it out right. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statements - Need Help
Does this work for you:
=IF(OR(J1="M",H1=0,I1<0),"Repair","Do Not Repair") ? -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Wonder" wrote in message oups.com... I am getting so confused by these If Statements!! I have 3 columns that I need to encorporate into my If Statement. I need it to say: If column J = the letter "M", then put "REPAIR", IF column H = 0, then put "REPAIR", IF column I < 0, "REPAIR", "DO NOT REPAIR" Does this make any sense?? It does in my head, but not sure if I typed it out right. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If Statements - Need Help
Hi
Try =IF(J1="M","Repair",IF(H1=0,"Repair",IF(I1<0,"Repa ir","Do not Repair"))) -- Regards Roger Govier "Wonder" wrote in message oups.com... I am getting so confused by these If Statements!! I have 3 columns that I need to encorporate into my If Statement. I need it to say: If column J = the letter "M", then put "REPAIR", IF column H = 0, then put "REPAIR", IF column I < 0, "REPAIR", "DO NOT REPAIR" Does this make any sense?? It does in my head, but not sure if I typed it out right. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating my own user defined function help statements | Excel Worksheet Functions | |||
| UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
| "IF Statements in Microsoft Excel | Excel Discussion (Misc queries) | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
Hybrid Mode
