| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Add-in: Open Database Connectivity available for Excel | Excel Discussion (Misc queries) | |||
| Vlookup formula - Excel Version 2002 | Excel Worksheet Functions | |||
| formula required for excel 2002 | Excel Discussion (Misc queries) | |||
| Formula Arrays VERY SLOW in Excel 2002 | Excel Worksheet Functions | |||
| How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Linear Mode
