Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Microsoft Excel in Microsoft works - how to open | Excel Discussion (Misc queries) | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Percentages | Charts and Charting in Excel | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |