What formula do I use for Grading?
I have a sheet used for grading our product. There is a final score for each product out of 36. I would like to use a formula that uses the final score to give the product a "Grade".
012 = C, 1323 = B, 2429 = A, 3036 = A+
How do I set up a formula to kick out a letter grade in a cell depending on a range of numbers in another cell in the same sheet?
Best Answer

Hi @Nate420
Try this and let me know if it works for you:
=IF([Final Score]@row = 0, "C", IF([Final Score]@row < 13, "C", IF([Final Score]@row < 24, "B", IF([Final Score]@row < 30, "A", IF([Final Score]@row < 37, "A+", "False")))))
If any grade exceeds 36 the word "False" will populate. You can replace "False" in the quotations reflect anything you wish, or add to the formula.
Answers

Hi @Nate420
Try this and let me know if it works for you:
=IF([Final Score]@row = 0, "C", IF([Final Score]@row < 13, "C", IF([Final Score]@row < 24, "B", IF([Final Score]@row < 30, "A", IF([Final Score]@row < 37, "A+", "False")))))
If any grade exceeds 36 the word "False" will populate. You can replace "False" in the quotations reflect anything you wish, or add to the formula.

@Mr. Chris This worked perfect thank you.
I would also like to add a formula to the same sheet that shows a Pass or a Fail depending on three other columns.
If Mold Present column say "No" & the Seeds per 100g column says "None" or & the Foreign Matter column says "No" mark the cell as a PASS. If Mold Present column says "Yes  Beige" or "YesGrey" or "YesBlack" & the Seeds per 100g column says "<5" & the Foreign Matter column says "Yes" mark the cell as FAIL.
Is this possible?
Help Article Resources
Categories
Check out the Formula Handbook template!