Look in the help index for LOOKUP. There is a good example

--
Don Guillett
SalesAid Software

"Andmor" wrote in message
...
I"ve collected all the marks for some 400 students and wished to convert
them
from percentials into letter grades. Here is the breakdown for the letter
grades:

90 A+
85 - 89 A
80 - 84 A-
77 - 79 B+
74 - 76 B
70 - 73 B-
etc...

Now i have my percentages starting in L6 and would like to have the letter
grades starting @ M6.

I was thinking a nested if statement? please help!

--
A.