If Statements - Need Help

W

Wonder

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

Roger Govier

Hi
Try
=IF(J1="M","Repair",IF(H1=0,"Repair",IF(I1<0,"Repair","Do not Repair")))
 
Top