IF Statement Required please
Solved/Closed
Related:
- Asistencia472.com this requires seriousness and an account registered in your name that will help you with these procedures
- Pals! I seriousely need some help!! - Forum - Windows
- Assistance required - Forum - Linux/Unix
- The other number which I used to registered is lost - Forum - Yahoo Mail
- My real account disabled - Forum - Facebook
- Can you recover my account - Forum - Facebook
8 replies
rizvisa1
Jun 1, 2010 at 12:29 PM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Jun 1, 2010 at 12:29 PM
See if this is what you want
=IF(AND(C2>=-5,C2<=3), "On Time", "Late")
OR
=IF(C2="", "", IF(AND(C2>=-5,C2<=3), "On Time", "Late"))
=IF(AND(C2>=-5,C2<=3), "On Time", "Late")
OR
=IF(C2="", "", IF(AND(C2>=-5,C2<=3), "On Time", "Late"))
Netscur
Jun 1, 2010 at 12:35 PM
- Posts
- 21
- Registration date
- Thursday July 23, 2009
- Status
- Member
- Last seen
- April 6, 2012
Jun 1, 2010 at 12:35 PM
Assuming your Varience is located in cell M7, try this:
=IF(M7<-5,"Late",IF(M7>3,"Late","On Time"))
-Netscur
=IF(M7<-5,"Late",IF(M7>3,"Late","On Time"))
-Netscur
Didn't find the answer you are looking for?
Ask a question
ok, going with Netscur's formula, if possible can you add:
AND IF O7 = 3000, PUT "IGNORE"
Thanks
Ant
AND IF O7 = 3000, PUT "IGNORE"
Thanks
Ant