Chronology | Current Month | Current Thread | Current Date |
[Year List] [Month List (current year)] | [Date Index] [Thread Index] | [Thread Prev] [Thread Next] | [Date Prev] [Date Next] |
Dan,
I'm not an excel user, but I suspect it has an IF function. Here's an if
function I use in Works. I calculate the numerical score in the C column,
then have an IF function assign a grade. It makes it easier to transfer
grades to the grade sheet.
=if(c2<0.6,"F",if(c2<0.7,"D",if(c2<0.8,"C",if(c2<0.9,"B","A"))))
Bob Carlson