Worksheet calculation different from calculator's

  • Thread starter Thread starter KARTX
  • Start date Start date
K

KARTX

Calculations in my worksheet differ from the same calculation performed with
a calculator by as much as 0.03. I have not been able to fix this with
ROUNDUP or ROUNDDOWN. Why does this occur and how can I eliminate the
discrepancy?
 
what are you calculating? what functions are you using? what makes you
think your calculator is right?
 
I am calculating state sales tax. My calculator and the state's agree -
Excel's does not. For example, in the calculation 66,566 times 6.25% o my
calculator and the state come up with 4,159.75. Using in the formula 66,566 *
..0625 in a cell results in 4,159.72.
Similar discrepancies occur all the way through the spreadsheet. I can only
surmise that there's a built-in round up or down function being performed and
I can't figure out how to discontinue it.
 
You're doing somthing wrong somewhere, because Excel comes up with 4160.375,
as do I when I use the old paper & pencil! Time for a new calculator!!
 
Perhaps the numbers in your message were entered incorrectly. 6.25% of
66,566 IS NOT 4,159.72 or even 4,159.75. It is 4,160.375. Excel and my HP
12C agree on that to the fraction of a penny.
 
My calculator and my version of Excel return a different result:

66,566 * 0.0625 = 4160.37500000000000
 
Ye Gods! I LOVE getting old. You are both absolutely right. Seems my eye hand
coordination is skewed but consistent. Every time I entered the larger number
in the spreadsheet, I made the same error. Thanks for taking the time to
respond. Don't suppose you have a cure for old timer's syndrome, do you?
Sheepishly,
Karen
 
It's clear that none of you are accountants. Because before doing any
sort of calculation, you should always ask, "What do you want the
answer to be?" THEN you find a way to make that work. ;-)
 
Back
Top