@ > Home > Contents > Conversion between score types Excel 97+

In German schools, high school scores convert to lower class' scores as follows:

pts score in words
15  1+ 
14  1  very good
13  1-
12  2+
:        etc.
04  4-
03  5+
02  5  poor (failure)
01  5-
00  6  nothing at all (failure)

There is no 6+, only a 6; but the difference from 5- to 6 is 1 point, not 2 as expected. 

=LEFT((18-A1)/3)&MID("+-",MOD(A1-(A1=0),3)+1,1) converts points to a score

=MAX(61-3*LEFT(A1)-CODE(MID(A1&",",2,1)),) converts a score to points (formula by Bernd Plumhoff)