Percentile formula help

1. Percentile formula help

Hello,
I am trying to use formula to automate a scoring card. There are 4 categories each worth 25%. Each category has 5 ratings as below

"Poor (0% score)"
"Fair (10% - 50%)"
Good (50% - 80%)
"Excellent (80% - 100%)"
"Outstanding (100% - 120%)"

For example: If you manually enter a score of 120% in B5 I'd like the total score for that category to be 25% in B6

let me know if this is not clear. Thanks

2. Re: Percentile formula help

hello like this?

scoring.xlsx

3. Re: Percentile formula help

You'll need a small adjustment in your LOOKUP formula:

``Please Login or Register  to view this content.``
Otherwise, any score below 10 will result in an error.

4. Re: Percentile formula help

missed that one.. thanks CheshireCat, appreciate it.

5. Re: Percentile formula help

Thanks for your speedy replies, I have updated vlady's sheet with an example

6. Re: Percentile formula help

Could you post an example worksheet with a few figures manually entered with explanation as to why those would be the results?

7. Re: Percentile formula help

you also need to clarify your boundaries
Poor (0% score)"
"Fair (10% - 50%)"
Good (50% - 80%)
"Excellent (80% - 100%)"
"Outstanding (100% - 120%)"
you cant have the same say 50% in both fair and good

8. Re: Percentile formula help

apologies, from your comments I realize I have not been clear at all. and assume people are thinking what I'm thinking....

I'll attach another .xls for example.

To note the top score is 25 but they can overachieve to 30.

Users Browsing this Thread

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

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