| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
make cell report zero if it's a negative number
If my formula in an Excel cell reports a negative number, for the sake of
adding up values in a column (SUM) how do I get that cell to just report zero value? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
make cell report zero if it's a negative number
=(MAX,0,your_formula)
Or change you SUM to SUMIF, with a condition of greater than 0. -- David Biddulph "Bob" wrote in message ... If my formula in an Excel cell reports a negative number, for the sake of adding up values in a column (SUM) how do I get that cell to just report zero value? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make a negative number zero | Excel Worksheet Functions | |||
| How to make the cell or font color red if the number is negative? | Excel Worksheet Functions | |||
| make cell entries a negative number | New Users to Excel | |||
| make negative number value to zero | Excel Worksheet Functions | |||
| make negative number value to zero | Excel Worksheet Functions | |||
Linear Mode
