Hi,
If i were to create a grading sheet: 0-50 = F, 51-60 = D, 61-70 = C, 71-80 = B, 81-100 =A
If in columnA I have numbers such as 81, 67, 45, 72 and in columnB I want to convert these values to the Grade A, B, C etc. How do I go about writing function for the cell in columnB?
Thank you so much,
T.
Hi,
here an option with IFS
Formula for B2= IFS(A2≤50,"F",A2≤60,"D",A2≤70,"C",A2≤80,"B",A2>80,"A")
Regards Ralf
Hi,
here an option with IFS
Formula for B2= IFS(A2≤50,"F",A2≤60,"D",A2≤70,"C",A2≤80,"B",A2>80,"A")
Regards Ralf
Hi,
here a option with XLOOKUP
Formula for B2= XLOOKUP(A2,{50;60;70;80;100},{"F";"D";"C";"B";"A"},"-",1,1)
Based on your region the , or the ; will be used to separate the different sections of a formula. If you write one thousand as 1,000.00 then the , is used as your formula separator. If you write one thousand as 1.000,00 then the ; is used as your formula separator.
Hope this will solve your question, please let me know if this worked for you or if something in unclear.
Regards Ralf
I would always recommend you dont hard code your rages into any formulas, I would make a new table that holds the scores and letters for reference, then use either a VLOOKUP or XLOOKUP to get the letter grade from it.
this not only helps if anything changes in the future, or allowing you to adjust for different classes easily, it also gives you a visual validation that the numbers you are using are accurate.
Thank you! :)
Thanks Ralf! :)
Creating a grading sheet
