Support Board

Date/Time: Wed, 27 Nov 2024 04:34:14 +0000

Post From: Column K Status Changes and Accuracy

[2023-09-14 13:54:22] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4120
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.