How do I eliminate negative values in a spreadsheet ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Grant,

You can make cells yielding negatives appear as 0 with formatting. Format -
Cells - Number - Custom tab:

General;"0";0

Or nothing:

General;;0

This is for display only; the formula will still be yielding a negative
value, and any formulas referring to the cell will not get 0, but the true
(negative) value. In that case, modify the formula to not yield a negative
value, as per JMB's post.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dividing - Negative Number by Zero 5
Question about conditional formatting of zeros in Excel 0
why do zero dollar values sometimes show red? 7
MAX() of a range of negative values? 7
Red cell for negative numbers in Excel 1
Graphing Negative Time 1
Negative Zero (-0.00) 2
Replace the minus value 3

Back
Top