LinkBack URL
About LinkBacks
Hi All
I'm looking for help to get a formula to auto populate the letter grades and Numeric grade from a course grade.
I've uploaded an example excel sheet.
Thanks in advance for any help
Regards
Hi All
I'm looking for help to get a formula to auto populate the letter grades and Numeric grade from a course grade.
I've uploaded an example excel sheet.
Thanks in advance for any help
Regards
Hi
You should use vlooukup function but your database should be changed a little
Uploaded sample file.
Appreciate the help? CLICK *
hi Treecko. your grades for B+ & B overlaps. 77-79 & 73-79. assuming the latter is 73-76, place the max number to get the particular grade say in I6:I17.
100
89
84
79
77
72
69
66
62
59
56
52
then try this in C6:
=INDEX(G$6:G$17,MATCH($B6,$I$6:$I$17,-1))
copy over. if you don't want the values in Column I, then:
=INDEX(G$6:G$17,MATCH($B6,{100;89;84;79;77;72;69;66;62;59;56;52},-1))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi Treecko, try this array formula in C6
Formula:
{=IFERROR(INDEX(G$6:G$18,MATCH(B6,VALUE(LEFT(F$6:F$17,2)),-1)+1),G$6)}
ps: press ctrl+shift+enter (instead of just enter) for array formula
_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved
Alvin
Thank you everyone for all your help. I'll keep these in a little file along with my other solutions.
Much appreciated and have a great and successful New Year in 2014
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks