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