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
- Create skype account with gmail - Guide
- This account has been deactivated due to inactivity, but we would love to welcome you back! click sign up below to create your new account. ✓ - Yahoo Mail Forum
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history ✓ - Facebook Forum
- Recover instagram account with facebook - Guide
- Free fire account transfer - Guide
8 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 1, 2010 at 12:29 PM
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
Posts
21
Registration date
Thursday July 23, 2009
Status
Member
Last seen
April 6, 2012
Jun 1, 2010 at 12:35 PM
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
