office 2003 Excel - SUM

[achyam]

The numbers in a column have 2 decimal places.
I need to ignore the decimal place numbers or display them as zeros in the
SUM answer.
Cannot find what to put in the formula?
The number to the left of the decimal point cannot be changed (rounded).

 

[Sheeloo]

Try
=ROUNDDOWN(SUM(A1:A20),0)

Change A1:A20 to your data range. This will ignore the decimals and show the
integer part.

 

[achyam]

Thanks "Sheeloo"

I don't think that that will work because it will round down the Integer.
After more searching I have found =TRUNC(SUM(A1:A20)) works ok without
affecting the integer.

It's all to do with Inland Revenue tax calculations?

 

[KC]

=TRUNC(SUM(B1:B5))
=INT(SUM(B1:B5))
does any of the above work for you?

-kc
*Click YES if this helps