Thread: How do I eliminate negative values in a spreadsheet ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JMB JMB is offline
external usenet poster
  
Posts: 2,062
Default How do I eliminate negative values in a spreadsheet ?
For example:
=MAX(0, SUM(A1:A10))


"grant" wrote:

I would like calcualed vales in cells to =zero if the calculation result is
negative/blow zero. In other words a threshold that values below zero are not
produced.
Reply With QuoteReply With Quote