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?

"KARTX" wrote:

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?

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!!

"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.

to get 4159.75, you need 66556, not 66566. Excel is right.

"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.

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.

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.

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

"Bob Umlas, Excel MVP" wrote:

to get 4159.75, you need 66556, not 66566. Excel is right.

"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.

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. ;-)

LOL!

--
Biff
Microsoft Excel MVP


"Spiky" wrote in message
...
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. ;-)