#1   Report Post  
albebach
 
Posts: n/a
Default Excel Formulas

When multiplying numbers in excel using formulas the answer seems to be
incorrect by a few hundreths of a point. When you compare the excel answer
with that of a calculator they are different. Why is this and can this be
changed?
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Not Excel per se, more of how computers work

http://www.cpearson.com/excel/rounding.htm



Regards,

Peo Sjoblom

"albebach" wrote in message
...
When multiplying numbers in excel using formulas the answer seems to be
incorrect by a few hundreths of a point. When you compare the excel

answer
with that of a calculator they are different. Why is this and can this be
changed?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
excel 2002 - copying formulas to another worksheet Greg Excel Discussion (Misc queries) 2 January 28th 05 11:23 PM
How to make Excel run limited number of formulas on a given worksh John Excel Discussion (Misc queries) 0 January 12th 05 05:29 PM
Way to make Excel only run certain formulas on a worksheet? jrusso Excel Discussion (Misc queries) 0 January 12th 05 05:23 PM
How do I get to master Excel functions and formulas? Basabjit Chowdhury Excel Worksheet Functions 3 December 29th 04 09:15 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"