View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arlene Arlene is offline
external usenet poster
 
Posts: 38
Default Adding Incorrectly - off by 1 penny

Please try multiplying the following mileage by .4 to get the reimbursement
amount.

185.27
128.3
198.64
168.66
143.94

You should get the following:

$74.11
$51.32
$79.46
$67.46
$57.58

Next add up the sum of those amounts.

The sum should be $329.93 but Excel is giving me $329.92.

If I type in the amounts alone (without the caluculation) the sum is correct.