office 2003 Excel - SUM

A

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).
 
S

Sheeloo

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

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

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?
 
K

KC

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

-kc
*Click YES if this helps
 
Top