View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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.