Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I eliminate negative values in a spreadsheet ?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I eliminate negative values in a spreadsheet ?
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. -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "grant" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i hide negative values in excel | Excel Discussion (Misc queries) | |||
Negative or zero values cannot be plotted correctly on log charts | Charts and Charting in Excel | |||
Get Excel to accept negative values using time-format | Excel Discussion (Misc queries) | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
Need formula to find and sum values in a different spreadsheet | Excel Worksheet Functions |