How do I eliminate negative values in a spreadsheet ?

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.
 
E

Earl Kiosterud

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
MAX() of a range of negative values? 7
Graphing Negative Time 1
why do zero dollar values sometimes show red? 7
Question about conditional formatting of zeros in Excel 0
How do I change my negative values to zeros in Excel? 1
Format Cells - Accounting - Discrepancy? 3
Returning Zero 10

Top