View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default 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.