Author Topic: How can we calculate grade in excel  (Read 2546 times)

Rachhpal singh

  • Guest
How can we calculate grade in excel
« on: April 02, 2012, 07:48:38 PM »
if A=20, B=16,C=12,D=4
 A     C    D   =?(LETTER GRADE)

Rachhpal singh

  • Guest
Re: How can we calculate grade in excel
« Reply #1 on: April 02, 2012, 07:55:44 PM »
WHAT IS FORMULA

ssgill79

  • Real Member
  • **
  • Offline
  • Posts: 217
  • Gender: Male
    • View Profile
Re: How can we calculate grade in excel
« Reply #2 on: April 02, 2012, 08:02:28 PM »
=IF(A1<4,"E",IF(A1<12,"D",IF(A1<16,"C",IF(A1<18,"B","A"))))

copy this formula and paste in the formula bar of the cell in which you want to add grade and replace "A1" with the cell from which number is to be checked for grade.

this will convert numbers below 4 to grade E
4-11 to grade D
12-15 to grade C
16-17 to grade B
18and above to grade A

« Last Edit: April 02, 2012, 08:05:35 PM by ssgill79 »

R S Sidhu

  • Real Savvy
  • *****
  • Offline
  • Posts: 4777
  • Gender: Male
    • View Profile
Re: How can we calculate grade in excel
« Reply #3 on: April 02, 2012, 08:37:17 PM »
THIS IS WORNG
IT SHOULD BE
0-4    E

5-8   D

9-12  C

13-16  B

17-20  A

R S Sidhu

  • Real Savvy
  • *****
  • Offline
  • Posts: 4777
  • Gender: Male
    • View Profile
Re: How can we calculate grade in excel
« Reply #4 on: April 02, 2012, 08:41:58 PM »
=IF(A1<4,"E",IF(A1<12,"D",IF(A1<16,"C",IF(A1<18,"B","A"))))

copy this formula and paste in the formula bar of the cell in which you want to add grade and replace "A1" with the cell from which number is to be checked for grade.

this will convert numbers below 4 to grade E
4-11 to grade D
12-15 to grade C
16-17 to grade B
18and above to grade



IN UR FORMULA   STUDENT HAVE  4 MARKS  GET  GRADE D WHICH IS WRONG  SAME FOR OTHER GRADE

ssgill79

  • Real Member
  • **
  • Offline
  • Posts: 217
  • Gender: Male
    • View Profile
Re: How can we calculate grade in excel
« Reply #5 on: April 02, 2012, 08:53:46 PM »
i have created the formula as per the data provided above by rachhpal singh. and moreover it is just to give you idea about the syntax of formula to convert numbers to grades , you should modify the formula as per your need. i have not claimed it to be according to the grades provided by edu deptt
« Last Edit: April 02, 2012, 08:55:58 PM by ssgill79 »

R S Sidhu

  • Real Savvy
  • *****
  • Offline
  • Posts: 4777
  • Gender: Male
    • View Profile
Re: How can we calculate grade in excel
« Reply #6 on: April 02, 2012, 09:06:20 PM »
OK

Bhatti

  • Member
  • *
  • Offline
  • Posts: 97
    • View Profile
    • Email
Re: How can we calculate grade in excel
« Reply #7 on: April 02, 2012, 09:13:41 PM »
I agree with you.

Rachhpal singh

  • Guest
Re: How can we calculate grade in excel
« Reply #8 on: April 02, 2012, 09:42:15 PM »
koiSS   lgn   AiBivAkqI   mulWkx (AOsq gRyf)
A   B   C   ?
D   E   A   ?
         
         
         
         

Rachhpal singh

  • Guest
Re: How can we calculate grade in excel
« Reply #9 on: April 02, 2012, 09:43:59 PM »
a1    b1      c1    d1
 A     E        D     ?

 

GoogleTagged



Original notification 5400 grade pay of lecturer and 5000 gp for master cadre

Started by RAJ

Replies: 24
Views: 20517
Last post December 11, 2011, 08:58:14 PM
by Ajay Pal Singh
pay grade news 10300-34800-4200..?

Started by krazzy4u

Replies: 26
Views: 8558
Last post August 17, 2015, 06:14:27 PM
by Satinder
PB. GOVT EMPLOYEES SPECIAL GRADE PAY (150) CLARIFICATION ???

Started by J.S.Sandhu

Replies: 20
Views: 16669
Last post January 03, 2012, 12:21:39 PM
by aaarvind
Salary & Grade of Govt Employees

Started by krazzy4u

Replies: 61
Views: 21596
Last post December 24, 2014, 06:20:43 PM
by Gaurav Rathore
Regarding Releasing the Grade of Junior Assitant as 50:50

Started by Guri

Replies: 1
Views: 918
Last post March 25, 2014, 10:47:14 AM
by Guri