Worksheet calculation different from calculator's
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? |
Worksheet calculation different from calculator's
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? |
Worksheet calculation different from calculator's
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. |
Worksheet calculation different from calculator's
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. |
Worksheet calculation different from calculator's
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. |
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. |
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. |
Worksheet calculation different from calculator's
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. |
Worksheet calculation different from calculator's
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. ;-) |
Worksheet calculation different from calculator's
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. ;-) |
All times are GMT +1. The time now is 02:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com