OR Function

[kstvns]

I have the following formula:

=IF(SUM(F36:O36)=0,E36,SUM(F36:H36)-SUM(I36:O36))*24
​

I believe the OR function will work, but I am having difficulty deciding where it should be. Side note: I am converting time notation to decimal notation; hence the *24.

I am seeking one of two results: Either the answer of the formula or zero if the result is a negative number.

 

[DonkeyOte]

I am seeking one of two results: Either the answer of the formula or zero if the result is a negative number.

See MAX:

=MAX(0,IF(SUM(F36:O36)=0,E36,SUM(F36:H36)-SUM(I36:O36))*24)

will return the greater of the two values (0 and formula result)

 

[kstvns]

Thank you!