Excel Column Summation
Display your numbers as 2 decimal places (or as General) instead of 1, and
they will add up to 11.0.
It is because you rounded them to 1 place that you've got the wrong answer.
--
David Biddulph
"Scott Adams" wrote in message
...
Thanks Stefi and Jacob --
I updated each function to round to 1 decimal as follows:
=ROUND(H2*$C$3,1)
The sum total still is high by 0.1
11.0
4% 0.4
15% 1.7
2% 0.2
31% 3.4
7% 0.8
17% 1.9
14% 1.5
5% 0.6
5% 0.6
11.1
"Stefi" wrote:
Instead of formatting try rounding to 1 decimal place: =ROUND(C1,1)
Regards,
Stefi
"Scott Adams" ezt írta:
I know this is likely an insanely simple situation, but it is early
Tuesday
and I am stumped.
I have a simple spreadsheet breaking hours down by percentage to spread
my
labor costs across multiple projects. All number cells are formatted
the
same: Numeric with 1 decimal place. However, when I enter my total
hours and
the math occurs, the resulting breakdown does not add back up to my
total
hours. It is almost always off by 0.1
TOT 11.0
4% 0.4
15% 1.7
2% 0.2
31% 3.4
7% 0.8
17% 1.9
14% 1.5
5% 0.6
5% 0.6
Is there some contraint that I can place on any cell to force this to
add up
correctly? I know it must be a decimal situation somewhere, but I am
stumped.
THANK YOU!
Scott
|