Nested IF statements returning 'FALSE' on time check

[ENZO22]

I am trying to write a formula to show the below:

General rule: If actual (C2) or forecast (B2) time is less than start time (A2) + 15mins then return status (D2) "on track", if its more than or equal to start time + 15mins then return status "late"

What I am trying to also include is a rule to check if actual time is 'blank' then use the rule against forecast time but if actual time is filled then over-ride the forecast time formula and check against actual time instead. I've written the below formula but is returning 'FALSE' when i have filled in actual time. Please help!

=IF(C2="",IF(B2<A2+TIME(0,15,0),"On track",IF(B2>=A2+TIME(0,15,0),"Late",IF(C2<A2+TIME(0,15,0),"On track","Late"))))

 

[Fluff]

You have some of the brackets in the wrong place, try

=IF(C2="",IF(B2<A2+TIME(0,15,0),"On track",IF(B2>=A2+TIME(0,15,0),"Late")),IF(C2<A2+TIME(0,15,0),"On track","Late"))

 

[Fluff]

Or a slightly shorter version

=IF(IF(C2="",B2,C2)<A2+TIME(0,15,0),"On track",IF(IF(C2="",B2,C2)>=A2+TIME(0,15,0),"Late"))

 

[ENZO22]

Or a slightly shorter version

=IF(IF(C2="",B2,C2)<A2+TIME(0,15,0),"On track",IF(IF(C2="",B2,C2)>=A2+TIME(0,15,0),"Late"))

amazing! thank you

 

[Fluff]

Glad to help & thanks for the feedback.

 

[Fluff]

For future reference

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Nested IF statements returning 'FALSE' on time check
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.