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.
|