Support Board
Date/Time: Sat, 07 Feb 2026 16:13:11 +0000
Post From: Column K Status Changes and Accuracy
| [2023-09-14 13:54:22] |
| Sawtooth - Posts: 4313 |
|
You need a final 'else' in the formula: =IF(AND(H41>=H48,H41<=H49),H50,IF(AND(H41>=H51,H41<=H52),H53,IF(AND(H41>=H54,H41<=H55),H56,FinalElse))) When H41 > H55, it doesn't know what to do. |
