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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top