View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Set negative numbers to zero. Do not calculate with negative valu

Depends upon your formulae. Post them.

--
HTH

Bob Phillips

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

"Excel Headache" <Excel wrote in message
...
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?