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

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

why not just use
=SUMIF(C:C,"0")
--
Don Guillett
SalesAid Software

"greg071190" wrote in message
...
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

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

"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
Please help if you can!
THANKS

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.

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

HTH,
Bernd

If(formula<0,0,formula)

"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
Please help if you can!
THANKS