Forum Discussion
Solved
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!
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
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
This will do it! Thanks so much!