Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Unanswered: Percentile Function

    I need to know the function to enter in order to make my spreadsheet give me

    What percent of this (2000) is that (200)

    We know the answer is 10% but I want my spread sheet to figure this automatically for any number.

  2. #2
    Join Date
    Sep 2004
    Charlotte, NC
    Put your Numerator in A1, your Denominator in A2, and in A3 put =round(A1/A2 ,3)and then format cell A3 as percentage. This will give you an answer to the nearest tenth of a percent. If you want it to the nearest whole percent, change ',3' to ',2'.


Posting Permissions

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