Hi Bob Phillips,

I used the formula that you gave it to me

=VLOOKUP(E5,{0,"F";60,"D";70,"C-";73,"C";76,"C+";80,"B-";83,"B";86,"B+";90,"
A-";95,"A"},2)

everything is okay, but the problem is when I insert a grade between(
90-95) which suppose to get me ( A-) i got an error.

please help me to solve this problem, soon.


thank you very much :)


--
DaredEvil590
------------------------------------------------------------------------
DaredEvil590's Profile: http://www.excelforum.com/member.php...o&userid=29085
View this thread: http://www.excelforum.com/showthread...hreadid=488117