Weird rounding in Sums of columns

  • Thread starter Thread starter Harold
  • Start date Start date
H

Harold

I have a simple worksheet in which one cell should be the
sum of a few others. It looks something like this:
A2=A1*.133, A3=A1*.12, A4=(SUM A1:A3). My problem is that
sometimes the sum in cell A4 is .01 less than it should
be. I assume it has something to do with rounding to two
decimal points. Is there a way to get A4 to equal the sum
of the actual numbers shown in the cells and not a sum
based on hidden strings of decimals? Sorry if this is
more confusing than it should be. Thanks for any help.
 
This will though permanently deprive you of that data from any raw numbers you have. Another
option, assuming your data is in A1:A100:-

=SUM(ROUND(A1:A100,2)) array entered using CTRL+SHIFT+ENTER
 
Thanks to both of you for the prompt responses! As these
are fairly small worksheets used for quick and dirty cost
calculations, I don't mind losing the raw number data.

I really appreciate the help.

-----Original Message-----
This will though permanently deprive you of that data
Click to expand...
from any raw numbers you have. Another
 
Back
Top