if function in excel

Question

I have scores from ranging from 1 to 14 that I would like to prorate down to a number out of 5. Is there a way to do this with an IF function?

Answer 1

Katherine,

In the end, the formula that matters is:

If you want a decimal Rank between 1 and 5

=((((B2-1)/13)*4)+1) where B2 is the value between 1 and 14

If you want a whole number Rank 1 and 5

=ROUND(((((B2-1)/13)*4)+1),0) where B2 is the value between 1 and 14

If this answered your question, I would appreciate an Upvote. If I didn't successfully answer your question, please leave a comment and let me know where my understanding of your question missed the mark.

John

Answer 2

Are you trying to assign a score of 1-5 to numbers between 1 and 14?

Try this:

=if(A1>12,5,if(a1>9,4,if(a1>7,3,if(a1>4,2,1)))

If A1 is greater than 12 = 5

if A1 is greater than 9 = 4

and so on...