ExcelBanter - My formula in Excel 2002 reads: =12.08*85.60 result 1034.048

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - My formula in Excel 2002 reads: =12.08*85.60 result 1034.048 (https://www.excelbanter.com/excel-worksheet-functions/52460-my-formula-excel-2002-reads-%3D12-08%2A85-60-result-1034-048-a.html)

My formula in Excel 2002 reads: =12.08*85.60 result 1034.048

Does anyone know of a patch, bug, options setting for Excel 2002 that will
correct this?

Anne Troy

My formula in Excel 2002 reads: =12.08*85.60 result 1034.048

Why is it a bug? Try this one: =0.08*0.6
What do you expect it to return? If you're looking for currency, perhaps you
want:
=round(12.08*85.60,2)
************
Anne Troy
www.OfficeArticles.com

"Ro" wrote in message
...
Does anyone know of a patch, bug, options setting for Excel 2002 that will
correct this?

All times are GMT +1. The time now is 11:03 PM.