Create a lookup table, I called it Crit, with your symbols in the first
column, and your minimum score per symbol in the 2nd column. Where you want
the result to show, leave a cell blank (I used E4), where you will enter the
student's score. In the next cell enter
=IF(E4="","",VLOOKUP(E4,Crit,2,TRUE)) (I used F4). If different, change E4
to the cell that will contain the student's score.

--
Hth

Kassie Kasselman


"Dr Traffic" wrote:

I want to calculate a letter grades based on marks. The letter grades
are divided up into a group of 10.

F 0 to 49
D 50 to 54
C- 55 to 59
C 60 to 63
C+ 64 to 67
B- 68 to 71
B 72 to 75
B+ 76 to 79
A- 80 to 84
A 85 to 90
A+ 90 to 100

"IF" only allows 7 functions. How can I get around this restriciton?
I'm somewhat of a novice when it comes to formula's so a bit of an
example would be a great help.

Thanks Rick