I am doing a demographic table, so negative numbers are nonsense, as in "five
negative people." The cell should revert from a negative number to zero and
be incorporated as such in successive calculations, not merely show as zero
but work in calculations as the original negative number. "-5=0", not -5
shows as zero but still functions as -5.

macoute

"JulieD" wrote:

Hi Lisa

if you mean "sum" as a total of a range of numbers
=MAX(SUM(A1:A100),0)

if you mean "sum" as a value, ie -200
then right mouse click on the cells choose format cell
choose the number tab, click on custom on the left and in the box on the
right type
#,##0;\0

Note: this will only change the way they look .. .not the actual value.

Cheers
JulieD



"Lisa" wrote in message
...
How do I make negative sums show as a zero on my spreadsheet?

Did you try the formula you were given
The value displayed by a formula is also the value that will be used in
further math operations that reference the cell with the formula
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"macoute" wrote in message
...
I am doing a demographic table, so negative numbers are nonsense, as in
"five
negative people." The cell should revert from a negative number to zero
and
be incorporated as such in successive calculations, not merely show as
zero
but work in calculations as the original negative number. "-5=0", not -5
shows as zero but still functions as -5.

macoute

"JulieD" wrote:

Hi Lisa

if you mean "sum" as a total of a range of numbers
=MAX(SUM(A1:A100),0)

if you mean "sum" as a value, ie -200
then right mouse click on the cells choose format cell
choose the number tab, click on custom on the left and in the box on the
right type
#,##0;\0

Note: this will only change the way they look .. .not the actual value.

Cheers
JulieD



"Lisa" wrote in message
...
How do I make negative sums show as a zero on my spreadsheet?