Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jray
 
Posts: n/a
Default Excel vs. calculator multiplication product discrepancy...

I'm experiencing a slight rounding error in comparing the Excel product of
simple multiplication equations versus the product achieved using a
calculator! Anyone know for certain how to adjust Excel to mirror the
calculator?
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default

Details, please.
What formulas, what values, what did your calculator give, what did Excel
give you and what do you consider right and why?

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Jray" wrote in message
...
I'm experiencing a slight rounding error in comparing the Excel product of
simple multiplication equations versus the product achieved using a
calculator! Anyone know for certain how to adjust Excel to mirror the
calculator?



  #3   Report Post  
bj
 
Posts: n/a
Default

what is the number of significant figures in the calulator?
addtionally for some fuctions, probably different algorithms were used in
the calculator than Excel.

"Jray" wrote:

I'm experiencing a slight rounding error in comparing the Excel product of
simple multiplication equations versus the product achieved using a
calculator! Anyone know for certain how to adjust Excel to mirror the
calculator?

  #4   Report Post  
Jray
 
Posts: n/a
Default

I've discovered my user error, reducing decimal places mid-equation... thank
you for you earnest efforts and assistance interest.
-John

"Niek Otten" wrote:

Details, please.
What formulas, what values, what did your calculator give, what did Excel
give you and what do you consider right and why?

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"Jray" wrote in message
...
I'm experiencing a slight rounding error in comparing the Excel product of
simple multiplication equations versus the product achieved using a
calculator! Anyone know for certain how to adjust Excel to mirror the
calculator?




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
Microsoft Excel in Microsoft works - how to open R J Gavin Excel Discussion (Misc queries) 3 September 16th 05 08:29 PM
VBA for Excel 2000 file is corrupt nkamp Excel Discussion (Misc queries) 0 May 26th 05 03:37 PM
Percentages Darryl Charts and Charting in Excel 2 May 21st 05 04:31 PM
Difference in number of Excel NewsGroups Hari Prasadh Excel Discussion (Misc queries) 1 January 25th 05 11:32 AM


All times are GMT +1. The time now is 04:18 AM.

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"