Log In
Register
Home
A problem with the formula
lea cohen
Member
Members
Forum Posts: 248
Member Since:
March 10, 2016
March 10, 2016
Offline1
July 9, 2023 - 7:49 am
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??
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members
Moderators
Moderators
Forum Posts: 1032
Member Since:
January 31, 2022
January 31, 2022
Offline2
July 9, 2023 - 2:56 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.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 7
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 919
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 339
David_Ng: 306
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Michael Denton
Nick Pascal
David Webb
Johannes Bruentrup
John Jay
Larry Silverman
David Rousseau
Melinda Heidemann
Jose Fuentes
Abigail Hernandez
Forum Stats:
Groups: 3
Forums: 25
Topics: 7072
Posts: 30993
Member Stats:
Guest Posters: 49
Members: 34469
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —