Values only

[Vicki]

I wish to add 3 cells but each cell contains a
multiplication formula so when I sum the 3 cells together
I do not get the correct decimal number. I am working with
dollar amounts

Cell 1 = 9,070.40*0.05 = 453.52
Cell 2 = 9,070.40*0.03 = 272.112
Cell 3 = 9,070.40*0.01 = 90.704

When rounded individually then summed manually (453.52 +
272.11 + 90.70)they give the result I am looking for.
However when I used the sum function it sums the
individual cells using the 3 decimals and then rounds to 2
decimals is there a way to only sum the number using 2
decimals?

 

[Frank Kabel]

Hi
You have to round the cells individually. e.g.
=ROUND(A1,2) + ROUND(A2,2)

 

[Bob Phillips]

Not necessarily,

=SUM(ROUND(C1:C3,2))

it's an array formula, so commit with Ctrl-Shift-Enter

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Better