Scoring out of 20 with Excel

Solved
Poulpe -  
 ijiu_è -
Hello,

I am writing to you because I have a question about the feasibility of an operation.

I have two scores: one is 1 out of 16 and the other is out of 9.

Since these scores are the maximum, how can I convert them to a scale of 20? (9 = 20 and 16 = 20).

Knowing that if I have an 8, it should be converted to a 10/20, just like if I have a 4.5, it should also be converted to a 10/20.

Thank you for any help you can provide.

3 réponses

PtiSwiss Posted messages 100 Registration date   Status Membre Last intervention   37
 
Hello

=((A1/16)*20) and =((A1/9)*20)

A1 should be replaced by the cell containing the grade.
16