View original (French)

Convert a score out of 20

Vanessa1200689 -  
diablo13800 Posted messages 3469 Registration date   Status Membre Last intervention   -
Hello,

I am currently entering the exam scores into an Excel spreadsheet.

The scores for 2 subjects are out of 20, and I would like to convert them so that each is out of 16.666, and therefore the total of the 2 scores gives a cumulative total out of 60.

Can you help me?

Thank you

Configuration: Macintosh / Safari 13.1.1

3 réponses

Réponse 1 / 3
diablo13800 Posted messages 3469 Registration date   Status Membre Last intervention   1 872
 
Hello,

For each of the grades use =A1/20*16.666

But I don't see how grades out of 16.666 result in grades out of 60...

--
To conquer without danger is to triumph without glory.
Pierre Corneille, Le Cid
1
Vanessa120689
 
In fact, there are 3 subjects out of 20. But the total of the 3 grades must be out of 50.

So each subject must be out of 16.666

Because 16.666 x 3 = 49.998 (and we round up)
0