| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula rounds differently in 2 spreadsheets
I received a spreadsheet attached to an email. I saved it into My Docs
folder and dressed it up a bit. Noticed that the formulas round differently i.e. the original spreadsheet calcs 6.15 and the copied one calcs 6.14 the formula is 27500/4475. It is displayed as =+a24/$c$6. The original calc 6.145251 and rounds to 6.15. The copied version calcs 6.143878 and rounds to 6.14 Any ideas? Both spreadsheets created in Office 2003. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
formula rounds differently in 2 spreadsheets
check that C6 does not show as 4476 rather than 4475
"Curious Kitten" wrote: I received a spreadsheet attached to an email. I saved it into My Docs folder and dressed it up a bit. Noticed that the formulas round differently i.e. the original spreadsheet calcs 6.15 and the copied one calcs 6.14 the formula is 27500/4475. It is displayed as =+a24/$c$6. The original calc 6.145251 and rounds to 6.15. The copied version calcs 6.143878 and rounds to 6.14 Any ideas? Both spreadsheets created in Office 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| How do I erase a formula that affect all spreadsheets in a workboo | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| How do I link 12 spreadsheets without exceeding the max formula l. | Excel Worksheet Functions | |||
Linear Mode
