Help with multiple formulas in cell

L-kat

New member
Joined
Apr 6, 2017
Messages
1
Reaction score
0
Points
0
I am trying to create a formula for CELL D that takes the number from CELL C. If the value is less than or equal to 5, I want cell d to promt a message saying " INSPECTION COMING DUE". If the value is less than or equal to 2 I want it to promt a message saying "INSPECTION DUE".

Thank you
 
L-kat,
See if this serves your purpose: =IF(C?<=2,"Inspection Due",IF(C?<=5,"Inspection Coming Due",""))
 
Back
Top