conversion of Grades to scores

[Wandera650]

Please how do you use the IFS function to score e.g. =IFS(A1=A,12,A1=A-,11,A1=B+,10,A1=B,9,A1=C+,8,A1=C,7,A1=C-,6,A1=D+,4,A1=D,3,A1=D-,2,A1=E,1)

Has some errors and i don't know how to correct it

[#2]

@Wandera650 You should to surround your letter codes with quotation marks.

=IFS(A1="A",12,A1="A-",11,A1="B+",10,A1="B",9,A1="C+",8,A1="C",7,A1="C-",6,A1="D+",4,A1="D",3,A1="D-",2,A1="E",1)

But perhaps better to use a lookup table in stead.

[#3]

Yes, It's correct.