+ Reply to Thread
Results 1 to 4 of 4

Excel vs. calculator multiplication product discrepancy...

Hybrid View

  1. #1
    Jray
    Guest

    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. #2
    Niek Otten
    Guest

    Re: Excel vs. calculator multiplication product discrepancy...

    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?




  3. #3
    Jray
    Guest

    Re: Excel vs. calculator multiplication product discrepancy...

    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?

    >
    >
    >


  4. #4
    bj
    Guest

    RE: Excel vs. calculator multiplication product discrepancy...

    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?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1