formula rounds differently in 2 spreadsheets

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

error with countif formula on when adding linked spreadsheets 0
formula finds values in apparently blank cells 1
How do I correct rounding errors in Excel formulas? 1
AUTOCALCULATION IN EXCEL IS NOT WORKING WHEN FORMULAS ARE COPIED 1
Excel won't calculate 4
Need help with formula to search and compare data in different col 4
Formatting in the formula bar 2
Formula results display only after pressing Enter key 1

Top