Set negative numbers to zero. Do not calculate with negative valu

[Guest]

I am working with fomulas that have diminishing values. I want the dimishing
values to stop at zero (not turn negative). Problem is, I'm getting negative
values that invalidate my data. Anyway way to "zero out" negative numbers?

 

[Guest]

=MAX(G5,0)

 

[Guest]

=if(formula<0,0,formula)

 

[Bob Phillips]

Depends upon your formulae. Post them.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

I am working with fomulas that have diminishing values. I want the dimishing
values to stop at zero (not turn negative). Problem is, I'm getting negative
values that invalidate my data. Anyway way to "zero out" negative

numbers?

 

[Guest]

Try something like =IF([your calculation]<0,0,[your calculation]).

Dave