finding grades based on grade range

Dear Forum memebers ,

Please provide user defined formula in excel to create grade based on grade range

Grade Grade range
A+ 3.5 -4
A 2.5-3.49
B+ 1.5-2.49
B 0.5-1.49
C 0 - 0.49


Thanks in Advance.

Originally Posted by martindwilson

=LOOKUP(A1,{0,0.5,1.5,2.5,3.5},{"c","b","b+","a","A+"})

Thanks !!