View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eqa Eqa is offline
external usenet poster
 
Posts: 52
Default ignore value when a negative.

I have a formula that is applied to a series of cells in some of the cells it
generates a negative value. How do I incorporate into the formula something
that would say if the result value is < o then show it as 0 and not as a
negative number.
Hope this is clear thanks in anticipation.

Eqa