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?
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?
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" <Jray@discussions.microsoft.com> wrote in message
news:713B3ED3-C2F5-48ED-817F-D1F04169F70E@microsoft.com...
> 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?
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" <Jray@discussions.microsoft.com> wrote in message
> news:713B3ED3-C2F5-48ED-817F-D1F04169F70E@microsoft.com...
> > 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?
>
>
>
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks