Forum Discussion
changing scales
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
JKPieterse The project below was scored on 120 points. I need to convert 59/120 to a 100 point scale. Some projects were scored out of 95 points, etc. I'm thinking a data table would do this for me (I did the below conversion manually) but haven't figured it out yet. Thank you for any assistance you can provide!
- 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!
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
Wouldn't that be =score/maximum_points*100
I think you got it, Hans. At least for the situation that S-C-K now has finally described. My own flight of fantasy took me off in a different direction altogether, which was intriguing, but apparently irrelevant.
