Notifications
Clear all
Topic starter
Hi, I have a problem with the formula in the attached file. Column Q has a complex formula
and the row in the file meets the last condition in the formula.
The problem is that the AND condition shows the result TRUE but the answer received in the cell is zero
instead of 4 hours. Why??
Posted : 09/07/2023 5:49 pm
That's a monster of a formula! As far as I can see, the fourth nested IF has no 'if_false' defined. For row 13 the value returned is FALSE (i.e. 0). And even when you in
FALSE (or 0) is not an error, thus the 2nd nested IFERROR statement is not evaluated.
Then the part of the formula with L13-R13 (=4:00) is part of the first IFERROR and never gets evaluated either.
In summary, you need to expand the 4th nested IF statement with an 'if_false' value. Perhaps you don't even need IFERROR here, but I don't really know.
Then, carefully check that all the following IFs, ANDs and ORs are indeed set correctly. Perhaps you need to look into the order in which these checks are made.
Posted : 10/07/2023 12:56 am
Topic starter
I got along with the formula. Thank you!
Posted : 10/07/2023 2:39 am
