formula for mark sheet

[mandarp22]

hi i need a formula to determine grade of student based on marks obtained by them.


GRADE A GRADE B GRADE C GRADE D GRADE E GRADE NO

MIN MAX MIN MAX MIN MAX MIN MAX MIN MAX MIN MAX

80 100 60 79 40 59 20 39 1 19 0 0


STUDENT MARKS GRADE

ABC 93 A


How to do it

please help

 

[nazmul_muneer]

Hi Pande

Think your data in

Column A=Student name

Column B=Marks

Column C=Grade

Data Started from A1

In C1 Type

=IF(B1=0,"No Grade",IF(B1<20,"Grade E",IF(B1<40,"Grade D",IF(B1<60,"Grade C",IF(B1<80,"Grade B","Grade A")))))

 

[nazmul_muneer]

Dear Pande

2nd Way

Type Grade criteria

A B C

1 19 E

20 39 D

40 59 C

60 79 B

80 100 A


A8=Student name

B8=Marks

C8=Grade

Type the formula in C8

=VLOOKUP(B8,$A$1:$C$5,3,1)

Done!

 

[mandarp22]

Dear muneer

Thanks it works fine..!!

 

[nazmul_muneer]

The 2nd formula is more smart!