+ Reply to Thread
Results 1 to 3 of 3

Converting Scores to Percentage

  1. #1
    Registered User
    Join Date
    03-27-2013
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    5

    Converting Scores to Percentage

    Hi,

    I have a score sheet that tracks our quality performance. The scoring system is as follows (we allow up to 1 decimal increments):

    1 - Highest
    2 - Above Average
    3 - Average
    4 - Below Average
    5 - Lowest

    I now need to get the equivalent percentage so they will look something like this:

    1 - 100%
    2
    3 - 85%
    4
    5 - 70%

    I'd like to create a formula wherein I can just input the score and its equivalent percentage would computed automatically. Anyone got any ideas?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,769

    Re: Converting Scores to Percentage

    Those input percentages appear to be exactly linear, so I would probably derive the equation for that straight line and use that. This might be easiest (since you probably don't actually need to know the equation) using the TREND() function. http://office.microsoft.com/en-us/ex...832.aspx?CTT=1

    1) Put the desired "fixed" values in a table. The TREND() function does not like blanks, so you will need to set it up accordingly:
    Please Login or Register  to view this content.
    2) To calculate the percentage at some "new_x", enter new_x into a cell.
    3) To calculate the percentage at that x, enter =TREND(known_y,known_x,new_x) into an adjacent cell. known_y etc are references to the appropriate cell(s) in the spreadsheet.

    Note that this only works as long as the "fixed" points form a perfectly straight line. If it doesn't form a straight line, then you will need to further define how you want to calculate the percentages.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-27-2013
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Converting Scores to Percentage

    Wow, thanks! I didn't even know that function existed. It works like a charm. Thank you, MrShorty!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Converting Time into a percentage
    By cherilannc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2012, 04:42 PM
  2. [SOLVED] Converting info to percentage
    By Donnchaog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-18-2012, 04:06 AM
  3. Converting irregular scores into % then grouping them
    By crashedinexcel in forum Excel General
    Replies: 13
    Last Post: 08-21-2010, 06:16 AM
  4. Converting percentage into text value?
    By Bandolin in forum Excel General
    Replies: 4
    Last Post: 05-29-2009, 01:52 PM
  5. Stop Excel from converting football scores into dates
    By excellentexcel in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-09-2009, 07:17 AM

Tags for this Thread

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