Math error off by .01

J

Jerad Hoff

I have a simple spreadsheet that tracks a credit card. I have a couple
of calculations that are off by one cent that are very strange.

For example:

F35=(SUM(G4:G33)) - (SUM(J4:J33)) == 2830.11 (this is OK)

=5000 - F35 = 2169.90 (should be 2169.89)

I'm sure this is an obvious problem. I tried searching past messags, but
my server only had 800+ messages or so.

I have all the fields involved marked as currency showing to two decimal
places.

This is the latest Excel for MacOS X, all the patches.

Thanks,

- Jerad
 
J

J.E. McGimpsey

Jerad Hoff said:
I have a simple spreadsheet that tracks a credit card. I have a couple
of calculations that are off by one cent that are very strange.

For example:

F35=(SUM(G4:G33)) - (SUM(J4:J33)) == 2830.11 (this is OK)

=5000 - F35 = 2169.90 (should be 2169.89)

I'm sure this is an obvious problem. I tried searching past messags, but
my server only had 800+ messages or so.

I have all the fields involved marked as currency showing to two decimal
places.

This is the latest Excel for MacOS X, all the patches.
Click to expand...

See http://www.mcgimpsey.com/excel/pennyoff.html for one explanation.
 
Top