Support Board

Date/Time: Wed, 27 Nov 2024 04:46:40 +0000

Post From: Column K Status Changes and Accuracy

[2023-09-14 12:28:51] Link To Thread - Link To Post [Go To First Post]
User772499 - Posts: 48
J26 is =IF(AND(H41>=H48,H41<=H49),H50,IF(AND(H41>=H51,H41<=H52),H53,IF(AND(H41>=H54,H41<=H55),H56))) H41 is =J45-J53/2*4.58 H48,H49,H51,H52,H54,H55 are the inputs for the different P/L levels H50,H53,H56 are the quantities for J26 Thanks,