or
=AVERAGE(CHOOSE(MATCH(A1:E1,{"A","B","C","D","E"}, 0),4,3,2,1,0))

confirmed with ctrl+shift+enter

Bernard Liengme wrote:
You have 5 letter grades (A thru E) in A1:A5 and want the GPA
=AVERAGE(CHOOSE(MATCH(A1,{"A","B","C","D","E"},0), 4,3,2,1,0),CHOOSE(MATCH(A2,{"A","B","C","D","E"},0 ),4,3,2,1,0),CHOOSE(MATCH(A3,{"A","B","C","D","E"} ,0),4,3,2,1,0),CHOOSE(MATCH(A4,{"A","B","C","D","E "},0),4,3,2,1,0),CHOOSE(MATCH(A5,{"A","B","C","D", "E"},0),4,3,2,1,0))

Note I have made A=4, B=3, etc. Some schools use 4.1 for A but the logic of
this escapes me.
best wishes & Merry Christmas
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"VD" wrote in message
...
=CHOOSE(MATCH(B3,{0;59;63;69;72;75;79;82;85;89;92} ,1),"F","D","D+","C-","C",
"C+","B-","B","B+","A-","A")

Or am i being too ambitious
--
VD, mistress in progress