How can i get a minus number to appear as a 0?

[greg071190]

In a spreadsheet i keep getting minus numbers and i want them to appear as
0's as this will make my sum's work
Please help if you can!
THANKS

 

[Don Guillett]

why not just use
=SUMIF(C:C,">0")

 

[Peo Sjoblom]

It is not clear to me what you mean, from where do you get minus numbers?
Formulas?

=MAX(0,formula)

will return zero if the formula returns negative numbers

Regards,

Peo Sjoblom

 

[hrlngrv]

greg071190 wrote...

In a spreadsheet i keep getting minus numbers and i want them to appear as
0's as this will make my sum's work

Perhaps these negative numbers are an indication that something is
very, very wrong in your workbook and that you need to fix things so
that these cells don't return negatives? On the other hand, if these
negatives are legitimate, then you either need to include them or sum
positive and negative values separately.

 

[Bernd Plumhoff]

Apply a number format like #,##0.00;"0"

HTH,
Bernd

 

[Brett]

If(formula<0,0,formula)