Worksheet calculation different from calculator's
My calculator and my version of Excel return a different result:
66,566 * 0.0625 = 4160.37500000000000
--
Biff
Microsoft Excel MVP
"KARTX" wrote in message
...
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.
|