I use a formula that does basically the same thing, converting point
totals into grades.
For example, if Column D contains total points (or percentages, as
shown below), I use this formula for Column E:

=IF(D190,"A",IF(D180,"B",IF(D170,"C",IF(D160," D","F"))))

I hope this helps.

-JMF