Thread: Sum Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KT KT is offline
external usenet poster
 
Posts: 47
Default Sum Function

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?