Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Apr 2002
    Location
    Pleasant Hill, CA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mathematics behind Percentage Calculation (2002/XP)

    I'm having trouble with calculating percentages. In the attached spreadsheet I am expecting a result of 97.2 in column B. Row 1 has the formula I'm using that returns 97.0. Row two has what I was expecting, based on my rudimentary mathematical skill. I have a feeling there is a reason Excel is returning the smaller result, but I don't understand the math behind it. Can someone explain or show me how to achieve the higher number? Thank you.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Mathematics behind Percentage Calculation (2002/XP)

    If you mean why are you getting 97.0% instead of 97.2%, it's because the 16.2 in row 1 is rounded up. The actual number is 16.1671% and if you used 16.1671 in row 2 you would get the same answer.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: Mathematics behind Percentage Calculation (2002/XP)

    You are getting a different answer because you are working with two different numbers. expand the columns C and D and format the cells to show say 10 decimal places.

    To get the same answer you should use the Round function. In the case of your formula the top one should be =Round(A1/B1,3).

    Regards,

    Tom Duthie

  4. #4
    Star Lounger
    Join Date
    Apr 2002
    Location
    Pleasant Hill, CA
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Mathematics behind Percentage Calculation (2002/XP)

    Thank you Rory and Tom. The Round function did the trick.

Posting Permissions

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