Thread: Set negative numbers to zero. Do not calculate with negative valu
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default Set negative numbers to zero. Do not calculate with negative valu
Try something like =IF([your calculation]<0,0,[your calculation]).

Dave
--
Brevity is the soul of wit.


"Excel Headache" wrote:

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?
Reply With QuoteReply With Quote