Grades to Marks

  • Thread starter Thread starter Greener2224
  • Start date Start date
G

Greener2224

I want to convert grades to marks A* is 58 points A is 52 etc. I have been
using lookup tables but they return A* as 52 points because of the wildcard
character any suggestions.
Thanks
 
You could do something like this...

=IF(A1="A*",58,<<your LOOKUP formula goes here>>)

Rick
 
Hi,

This works for me. Build a table like this which in my case is in columns A
& B

A* 58
A 52
B 44

Then use the formula
=VLOOKUP(E1,A1:B3,2,FALSE)
With the lookup value in E1


Mike
 
=LOOKUP(A1,{0,25,30,35,40,47,50,52,58},{"F","E","D","C","B","A-","A","A+","A*"})

adjust the mark thresholds and grades to suit

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Thanks Mike this exactly what I wanted I had VLOOKUP(E1,A1:B3,2,1) and just
changing the 1 to false works well
 
Hi,

Hi,

Your welcome and thanks for the feedback. Your formula would have worked had
you sorted column A.

Mike
 
Back
Top