Excel is totaling wrong
 

I am having a problem with the sum on only one cell of my spreadsheet. I
have currency in cells G2 to G7, (ex: $64,000.00) I have a percentage in
cells H2 to H7 (ex: 2.75%) I am multiplying those into cells K2 to K7 (ex:
k2=G2*H2) Then I am totaling down K2 - K7 with autosum, but the total is
wrong! It is off by 2 cents in this case, if I change the numbers in column G
it might be off by 1 cent or something. If I just copy the numbers in K2 -
K7 into other blank cells, then total it, they work fine. All of the numbers
are formatted correctly: currency, percentage, and then currency,
respectivly. This is one section out of many on my spreadsheet that look
like this, and this is the only cell I am having trouble with. Please help!

note: Columns G and H are all entered manually, Column K is a formula, all
entered data is correct.

Excel is totaling wrong
 

http://www.mcgimpsey.com/excel/pennyoff.html



--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Daxy" wrote in message ...
|I am having a problem with the sum on only one cell of my spreadsheet. I
| have currency in cells G2 to G7, (ex: $64,000.00) I have a percentage in
| cells H2 to H7 (ex: 2.75%) I am multiplying those into cells K2 to K7 (ex:
| k2=G2*H2) Then I am totaling down K2 - K7 with autosum, but the total is
| wrong! It is off by 2 cents in this case, if I change the numbers in column G
| it might be off by 1 cent or something. If I just copy the numbers in K2 -
| K7 into other blank cells, then total it, they work fine. All of the numbers
| are formatted correctly: currency, percentage, and then currency,
| respectivly. This is one section out of many on my spreadsheet that look
| like this, and this is the only cell I am having trouble with. Please help!
|
| note: Columns G and H are all entered manually, Column K is a formula, all
| entered data is correct.