IF statement
Solved/Closed
Related:
- IF statement
- Fenix internet on bank statement - Guide
- Application for bank statement sbi - Guide
- Excel if statement with text - Guide
- How many if statements can you nest - Guide
- Vba case statement with string - Guide
1 response
Ok, just swap the order in which you check for status. So check for a completed late first, completed on time next, and so on.
Also, on first check, use this:
If (and (b2 <>"", a2 <b2),"COMP LATE",
So on first logic test, use AND ().
AND (FIRST TEST, SECOND TEST)
IF (AND (FIRST, SECOND), TRUE, FALSE)
Also, on first check, use this:
If (and (b2 <>"", a2 <b2),"COMP LATE",
So on first logic test, use AND ().
AND (FIRST TEST, SECOND TEST)
IF (AND (FIRST, SECOND), TRUE, FALSE)
Aug 30, 2019 at 08:28 AM
Thank you for your quick response.
Just tried changing the order, however, still only first 2 conditions are returned.
Maybe, I did not explained clearly what I needed the formula to do, but basically I need all 4 returned values available.
i.e.
if B2 is not filled, than the value in C2 is either Open Late / On Time and when B2 is filled, then the value returned to be based on condition between A2 and B2 --> Completed On time / Late.
for some reason, the current formula only works for the first 2 conditions.
Not sure what am I missing in the formula, or even if this is the right one to use
Aug 30, 2019 at 08:45 AM
My apologies as only saw first 2 lines of your reply and completely omitted the second part of your reply stating to use AND().
In meantime sorted the issue with below:
=IF(B2="",(IF(A2<Today(),"Open-Late",IF(A2>=Today(),"Open-On time"))),IF(A2>=B2,"Completed-On Time",IF(A2<B2,"Completed-Late","")))
Also just to confirm that using the formula suggested by you, also solved the issue.
Thank you a lot for your quick response and help.
Aug 30, 2019 at 09:03 AM