Thread: Set negative numbers to zero. Do not calculate with negative valu
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default Set negative numbers to zero. Do not calculate with negative valu
=if(formula<0,0,formula)

"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