Hi everyone. I am very much an Excel newbie, and I would like help on the attached file.
I am trying to sort out what is the best formula in G6, if I would like it to show the right score from column B depending on what an achievement numeric could be.
It is quite straightforward, where if the achievement is 1%, the score is 100%, and if the achievement is 90%, the score is 11%.
Been trying to read, learn how to write formulas, and did some attempts but continued to be stuck what what I want to create.
Would anyone please be kind to review the attached and provide some help, please? Thank you.
Bookmarks