Worksheet calculation different from calculator's
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.
"KARTX" wrote:
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.
|