What will be the easiest formula for assigning Grades in Column B ?

Question

What will be the formula for assigning Grades in Column B ?	
If Column A = marks i.e.72	
	
Grade scale:	
>=92	"A+"
>=82	"A"
>=72	"B+"
>=65	"B"
>=55	"C+"
> =48	"C"
>=40	"D"
>=35	"E"
<35	 "F"

Zuhair Bukhari · Answer

Usually the IF formula is used for such calculations, however a vlookup formula can be applied instead as it is short and easy to do.

The formula in column B would be: =IF(ISBLANK(A2),"",(VLOOKUP(A2,$E$2:$F$10,2,TRUE)))

Kindly check the image below, just type the grading in a separate area and use the above formula with "approxiamte match"

Thanks,

Mohammed Kalache · Answer

You're Gonna Like It ,

A13 Is The Student Grade

=IF(A13>=92,"""A+"" ",IF(A13>=82,"""A"" ",IF(A13>=72,"""B+"" ",IF(A13>=65,"""B"" ",IF(A13>=55,"""C+"" ",IF(A13>=48,"""C"" ",IF(A13>=40,"""D"" ",IF(A13>=35,"""E"" ",IF(A13<35,"""F""","")))))))))

خدمات بيت.كوم

استخدم تطبيق بيت.كوم

ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

What will be the easiest formula for assigning Grades in Column B ?

عمليات البحث الشائعة

المزيد من الأسئلة المماثلة