Off by .10

[Guest]

I have a spreadsheet set up to ballance my checkbook. It's always off by
exactly .10 cents every time I balance it. Why is that? Thanks in advance.

 

[Guest]

Since you didn't post more details or any of the formulas you're using...
Here are a couple guesses:

If you're importing or copying the values, perhaps some of the numbers have
more than 2 decimal places of values. For example 100.004 would appear to be
100.00. The cumulative effect totalling to 0.10

or
You really are off by 0.10 and need to find the variance.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Niek Otten]

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


--
Kind regards,

Niek Otten

|I have a spreadsheet set up to ballance my checkbook. It's always off by
| exactly .10 cents every time I balance it. Why is that? Thanks in advance.

 

[Dave Peterson]

If you're balancing your checkbook, I'm guessing you have a typo to be that far
off.

I'd recheck the data.

 

[Dave Peterson]

ps, you meant 10 cents, right--not 1/10 of a cent???

 

[edcosoft]

If you never correct it so that a month-end balances, every month
thereafter will be off by that 10 cents. So, do you correct it and
it's still generating a new 10 cent error? or did you never correct it?
ed