Forum Discussion
S-C-K
Aug 28, 2023Copper Contributor
changing scales
I'm trying to convert various scoring scales to a common 100 point scale. I can do it manually, line by line, but can't find a formula to do it for me. Ideas? Thank you!
- Aug 28, 2023
I was hoping I could find a way to do this more quickly given that I have multiple projects with various totals to convert.
Easily done: I suggest a table that shows the max available for each project, e.g.,
and then a lookup formula that accesses the table
=(F2/VLOOKUP(E2,$A$2:$B$5,2,0))*100
See the attached example
HansVogelaar
MVP
S-C-K
Aug 28, 2023Copper Contributor
Yes, that is the formula I'm using to do it manually. I was hoping I could find a way to do this more quickly given that I have multiple projects with various totals to convert. Thanks for your help!
- HansVogelaarAug 28, 2023MVP
- S-C-KAug 28, 2023Copper ContributorThank you!
- mathetesAug 28, 2023Silver Contributor
I was hoping I could find a way to do this more quickly given that I have multiple projects with various totals to convert.
Easily done: I suggest a table that shows the max available for each project, e.g.,
and then a lookup formula that accesses the table
=(F2/VLOOKUP(E2,$A$2:$B$5,2,0))*100
See the attached example
- S-C-KAug 28, 2023Copper ContributorThis will do it! Thanks so much!
- nqnicholsApr 02, 2024Copper ContributorThis is helpful. How would I adjust for scales that are inverted? Specifically, I'm trying to normalize a scale that runs from 1-3 where 1 is max and actuals would come in at decimals between the range of 1-3.