false>0=true

[ZOHAR]

Respected,
The problem(error -originally it should show 0) in p54 is due to data of L54 (which is returning as FALSE)
Zohar
THANKX IN ADVANCE
[email protected]

[mudraker]

I am no formula expert

the formula in L54 does not have an else option of the 1st if formula

IF(OR(H54>0,I54>0),more if statements, no option so displays false)

try

=IF(OR(H54>0,I54>0),IF(C54>23,(ABS(H54-G$49))*(K54), IF(OR(C54<23,C54>18),(ABS(H54-H$49))*(K54), (ABS(H54-I$49))*(K54))),0)