Here's the formula--just make sure to edit the cell info (here it's W2) in each place it occurs:
=if(W2="4+",98,if(W2=4, 91, if(W2="4-", 83, if(W2=3, 75, if(W2=2, 65, if(W2=1, 55, 0))))))
Change Levels to Percentages Quickly Print
Modified on: Mon, Mar 15, 2021 at 8:24 AM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.