Weird rounding in Sums of columns

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

Ken Wright

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
 
H

Harold

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
 
Top