how would i get an 'grade point average' using this formula
 

=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

how would i get an 'grade point average' using this formula
 

Not sure EXACTLY what you are looking for but within the constraints of a
formula similar to that you could replace the letters with their
corresponding number
A=4
B=3
C=2
D=1
F=0
Sum and then divide by classes taken.
Not sure if this is even in the realm of your question but its how I read it

--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"VD" wrote:

=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

how would i get an 'grade point average' using this formula
 

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

how would i get an 'grade point average' using this formula
 

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

how would i get an 'grade point average' using this formula
 

Neater!
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
oups.com...
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