incorrect totals using rounded numbers

A

Alexis

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

how to get a range of cells rounded off to the nearest value? 3
Rounding Effecting Sum 2
Rounding 6
incorrect calculations 3
To stop the rounding of numbers 1
Divide a # into 3 #'s rounded to a whole # 9
Rounding Problem 3
Rounding question 9

Top