Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Excel not calculating like my calculator - needs to round or not round

  1. #1
    New Member
    Join Date
    Nov 2008
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel not calculating like my calculator - needs to round or not round

    On my calculator, if I divide 462,534.05 by 335 I get 1,380.70. Then if I times 1,380.70 by 335 I get 462,534.50. Which is what I need it to be because I need to calculate the difference of a figure not dividing equally.

    On excel, if I divide 462,534.05 by 335 I get 1,380.70. Then if I times 1,380.70 by 335 I get the SAME result of 462,534.05.

    I have to account for the difference of not dividing equally so there is some format or accounting function that's preset that I don't want but I have no idea how to fix it or format my excel sheet to calculate as my calculator would.

    Please can someone help? Thanks!

  2. #2
    MrExcel MVP shg's Avatar
    Join Date
    May 2008
    Location
    The Great State of Texas
    Posts
    20,465
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Excel not calculating like my calculator - needs to round or not round

    On excel, if I divide 462,534.05 by 335 I get 1,380.70.
    No, you get 1380.69865671642, which you may have displayed as 1,380.70.
    Then if I times 1,380.70 by 335 I get the SAME result of 462,534.05.
    That's because it's using the full precision of the result above. And that's what you'd expect, is it not?

  3. #3
    MrExcel MVP AlphaFrog's Avatar
    Join Date
    Sep 2009
    Posts
    15,769
    Post Thanks / Like
    Mentioned
    8 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Excel not calculating like my calculator - needs to round or not round

    Set this option in Excel...

    Excel 2007 or later:
    Precision as displayed

    Excel 2003 or before:
    From the Excel menu, select Tools\ Options
    Select the "Calculation" tab
    Check the "Precision as Displayed" checkbox

  4. #4
    New Member
    Join Date
    Nov 2008
    Posts
    35
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel not calculating like my calculator - needs to round or not round

    AlphaFrog - that option for 2007 is exactly what I was looking for thanks!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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