Enter in D2

=LOOKUP(C2,{0,40.1,50.1,60.1,70.1,80.1,90.1},{"Not
Graded","F","E","D","C","B","A+"})

Gord



On Wed, 16 Apr 2014 00:39:29 -0700 (PDT), wrote:

On Saturday, 20 September 2008 18:07:10 UTC+5:30, wrote:
Hi,

I agree VLOOKUP; however, the lookup table should be set as follows:

Mark Grade
0 Not Graded
40 F
50 E
60 D
70 C
80 B
90 A+

Headers are optional

Alternatively if you want to use a formula the following one can be
placed in D2 and copied down.

=IF(C2=90,"A
+",IF(C2=80,"B",IF(C2=70,"C",IF(C2=60,"D",IF(C2 =50,"E",IF(C2=40,"F","Not
Graded"))))))

Cheers