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.

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.

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.