Use Nested IF & VLOOKUP formula for Grading

 
Example :

		GRADE
Student	Score	Nested IF	Vlookup Table	Vlookup Constant		Score	Grade
Billy	58	F	F	F		0	F
Tamra	64	D	D	D		60	D
Cheslan	83	B	B	B		70	C
Doug	72	C	C	C		80	B
Nicole	93	A	A	A		90	A
Fran	89	B	B	B
Lester	77	C	C	C
	Nested IF:	=IF(Score>=90,"A",IF(Score>=80,"B",IF(Score>=70,"C",IF(Score>=60,"D","F"))))
	VLOOKUP Table:	=VLOOKUP(B3,$G$3:$H$7,2,TRUE)
		=VLOOKUP(B3,GradeLU,2,TRUE)
	Vlookup Constant:	=VLOOKUP(B3,GradeLookup,2,TRUE)