nested if replacement

[lezawang]

Hi
I want do check student marks and based on the value I will make excel to type a,b,c,d,f.
If >80 then A, if >70 then B etc. I can do that using nested if. But lets say I have 10 conditions, is there better way to do that? if function will be complicated. I wonder if there is something easier. Thank you.

 

[jtakw]

Hi,

Something like this:

Book1
	I	J
1	81	A
2	92	A+
3	55	D
Sheet300

Cell Formulas
Range	Formula
J1	=LOOKUP(I1,{0,11,21,31,41,51,61,71,81,91,100},{"Z","Y","X","W","F","D","C","B","A","A+","A++"})