Nested IF statements returning 'FALSE' on time check

Cross-posted at https://www.mrexcel.com/board/thread...check.1215144/

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"))))

Screenshot 2022-08-30 173116.jpg

I would imagine you need something like this:

Formula:

Please Login or Register  to view this content.

try:

Formula:

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

I have add the link to your post because it is your first post.

The reason we require cross-post links is so we don't waste time working on something that's already solved. You accepted a solution as correct at the other site 90 minutes ago, so TMS and dosydos have wasted effort.