incorrect totals using rounded numbers

G

Guest

Formula for col. H is =SUM(C8*F8) where C8 is a dollar amt with 2 decimal
pts. and F8 is a figure formatted as "custom" but is actually a percentage
displayed as 0.1234567 (7 decimal pts.) The result displays as a dollar
amount with 2 decimal points. All is well UNTIL I total column H, using
=SUM(H8:H20). The total is off 2 cents! Apparently it is not totaling the
figures displayed as currency with 2 decimal points, but rather the unrounded
results of of the formula "=sum(C8*F8). How do I correct this???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding Effecting Sum 2
Rounding 6
why is answer rounded up? 1
How do I get Excel to correctly add a column of numbers that have. 4
Mail Merge - Thousand separators & Decimals 0
Mail Merge - Thousand separator and decimals 1
numbers to text with formatting 1
Index and match 3

Top