Sum Function


K

KT

I have cells that have numbers that are 3 and 4 digits beyond the decimal
point . I need them to have 2 digits beyond the decimal point. So I used the
=ROUND(cell,2) to round to 2 digits beyond the decimal. However, the sum of
my original column and the sum of my new column are different from each
other. They should be the same.

How do I truncate the extra digits beyond the decimal point without changing
the sum?
 
Ad

Advertisements

G

Gary''s Student

If you use the ROUND() function, you are really changing the values that are
being tallied. To get the SUM to be the same, don't use ROUND; instead
format the cells to:

Format > Cells... > Number > Number > decimal places 2
 
Ad

Advertisements

D

David Biddulph

If you don't want to change the underlying value, but want to display with 2
decimal places, use Format Cells/ Number/ 2 places instead of ROUND.
If you use ROUND, it changes the numbers, and hence the total is likely to
change.
 

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