electronic gradebook
=IF(A189,"A",IF(A169,"B",IF(A159,"C",IF(A149," D",IF(A1<50,"F",0)))))
You will of course have to change the numbers in the formula for your D and
F etc.
"shug" wrote:
how do i put in the formula to get a letter grade by using percentage. for
instace 100 - 90 = A
89 - 70 = B and so on using Excel.
|