Formula Calculating Minus Values

[Russ]

I have the Excel Application for calculating production
run values. The only thing is that at times it brings
negative results. Example being total run time =Cell M5
35999 minutes, then the calculation mentioned earlier =
Cell M6: D71+((C8-C7)*24*60)-H2-C11 (which is 5720 minutes
minus 0, minus 5760 minus 1440 equals -1480). This number
at times is a positive numbers and the calculations work
well.

This minus Cell M6: -1480 is then supposed to be deducted
from Cell M5: 35999 to give me Cell M7: 34559, instead I
get Cell M7 37479. This, increase in instead of decrease
throws everything else off.

Is there a method of creating the formula to instead of
increasing the ending values due to negative numbers,
simply drop the negative and turn it around?

 

[Bob Phillips]

Russ,

When you say drop the negatives, do you mean just take the absolute value of
the number, or do you mean assume negatives as zero.

If the former, try
Cell M6: =ABS( D71+((C8-C7)*24*60)-H2-C11)

If the latter, try
Cell M6: =MAX(0, D71+((C8-C7)*24*60)-H2-C11)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Jack]

Russ,

This formula in M7 will fix the prob:

=IF(M6<0,M5+M6,M5-M6)


Laters, Jack