Grading Scores
Everything is coming back as a "D"
"Jacob Skaria" wrote:
Try the below
=IF(AND(A10,A1<=100),LOOKUP(A1+0,{0,90,95,98},{"D ","C","B","A"}),"")
If this post helps click Yes
---------------
Jacob Skaria
"dchristo" wrote:
I need a formula for
if 100 - 98 = A
97 - 95 = B
94 - 90 = C
90 = D
Thank you for you help.
|