View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default 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.