# Change Letter Grade To Number Grade

Mar 30, 2008
I have a range of cells C11:C29,G12:G18,G20:G23,G25:G26,G28:G29,C33:C42,G33:G42,C46:C47,G46:G47,C51:C54,G51:G59,C58:C59 that contains letter grades (egs. A+,C- etc). I need the code for a macro that checks each cell from this range and if the value of the cell is A+ then the cell's value changes to 100, if the cell's value is A then change the cell's value to 98, if cell's value is B+ then change to 88 ...and so on...you get the idea (i will complete the rest of conditions but i just need the basic code).

View 6 Replies
ADVERTISEMENT
May 9, 2006

I have figured out how to assign a letter grade to a number, but am having trouble assigning it the other way, a number to a letter grade. For instance: If a student gets an A, I want the column next to it to indicate that the A represents a 4; a B represents a 3; a C represents a 2; D a 1; and F a 0. This will allow an easy grade point average calculation.

A 4 History

C 2 Math

A 4 English

B 3 Physical Ed

D 1 Science

GPA 2.80

View 3 Replies
View Related
Jul 10, 2013

I am compiling a master spreadsheet to analyse progress of students. I have their potential grades in one column and their latest progress grade in another.

I would like an automatic look up of the potential to the progress grade so that if their current grade is BELOW their potential that gets highlighted one colour, if it is above, another colour.

One issue is that the grades are all letters (S, A, B, C, etc.) and that some potential grades are 'dual' (i.e. A/B, S/A) which complicates the issue somewhat.

View 7 Replies
View Related
Jun 13, 2006

my Excel teacher doesn't even know how to do this! The chapter is Working with Multiple Worksheets and Workbooks, and we went into linking workbooks, linking worksheets, using the VLOOKUP function, and saving workbooks as templates. This is Case Problem 2 and i'll attaching the file.

It says:

1. On the Grading Criteria worksheet, enter the text "Exam Average" in cell A1

and the text "Grade" in cell B1.

2. In the range A2:B6, create a lookup table for the range of grades specified by Professor Templeton. (Hint: Each letter grade should be matched up with the lowest score possible for that grade.)

Here are the specified grades:

0 to 49 = F

50 to 59 = D

60 to 74 = C

75 to 89 = B

90 to 100 = A

3. Insert a formula in Column E of each worksheet to calculate the overall score of each student based on the grade table you entered in the Grading Criteria worksheet.

View 9 Replies
View Related
Aug 11, 2007

creating a function to turn a percent (0-100) into a letter grade, I am creating a gradebook spreadsheet.

I think VLOOKUP is the way to go here, but I do not understand vlookup at all no matter how many times I try to look at demos or read how-tos.

I created two columns, one with what the grade entails (93-100 , 90-93 and so on) and the next column has A, A-, etc. But I can't get vlookup to work, any suggestions? I am pretty noob when it comes to excel.

View 9 Replies
View Related
Oct 9, 2008

Newbie here. I have a very frustrating problem. I am using excel for my gradebook at school. I've tried several different ways to assign a letter grade to an number average. It works fine each different way I do it, VLOOKUP, IF, etc. But, I have about 5 grades out of 100 which give the wrong letter grade. For instance, my scale says that a grade of 85 should be lowest limit of a "B", but I get a "C" returned in the cell instead. Like I said, it only happens on a few grades. The biggest majority work fine. I can't figure out why. Any ideas? Attached is one of the "problems" with a student's grades. Note the Final Avg with a grade of "C", it should be "B".

View 12 Replies
View Related
Feb 14, 2009

I, too, am trying to use excel to the fullest. My first issue is, I would like to convert the numberic grade in one cell to a letter grade in another cell. I am not really good with all the vocabulary, but would love to learn it, and can copy a formula pretty well!!!! Not so good with functions and macros but would love to learn. All help appreciated.

View 11 Replies
View Related
Dec 29, 2013

I created an Excel 2010 macro enabled workbook (.xlsm) which calculates the letter grades of test scores between 1 and 100.

To use the workbook:

1. Put the scores in one column of the open worksheet.

2. Select the first score with the mouse (i.e. make this the "active cell").

3.Click on the "Calculate Grades" button on the sheet.

Public Function LGrade(ByVal score As Variant) As String

'Returns the letter grade based on a test score.

On Error GoTo ErrHandler

Select Case score

Case Is > 100: LGrade = "A+"

Case 95 To 100: LGrade = "A"

Case 90 To 94: LGrade = "A-"

Case 87 To 89: LGrade = "B+"

[code].....

View 4 Replies
View Related
Nov 28, 2012

Listed below are the grades for a student. Some columns have blanks. I have to find the highest grade (A being the highest) in the range.

I'm going up with the opposite (F) with this formula:

=CHAR(MAX(INDEX(CODE(A22:M22&CHAR(1)),0)))

How do I get A?

I'm using Excel 2007

A

B

C

B

D

E

A

A

B

F

View 6 Replies
View Related
Oct 3, 2006

Need to write a formula that would assign a letter grade (in row W) to the average in row V, based on the school's scale. So, row V contains my averages (in % form) and I want row W to have the letter equivalents.

93+=A

85-92=B

75-84=C

67-74=D

<66=F

View 2 Replies
View Related
May 5, 2006

I'm putting together a mark book for school and have a problem with VLOOKUP distinguishing between what used to be a top grade, ie A, and the new top grade, A*.

I want to convert the grade to a number but VLOOKUP can't tell the difference between A and A*. I've attached a sample worksheet.

View 8 Replies
View Related
Apr 6, 2014

In a worksheet of marks of students, i have entered grades A,B,C,D,AND E.Grades are entered in cells o3,AB3,AO3,BB3 AND BO3.

In BQ3,I want to get -in the range of O3:BO3

a)how many "A" are there?

It should display for example A=2,

b) how many "B" are there?

It should display for example B=2,

c)how many "C" are there?

It should display for example C=2,

d)how many "D" are there?

It should display for example D=2,

e)how many "E" are there?

It should display for example E=2.

In BR3, I want to get >

If A=10, B=8, C=6, D=4, E=2 then

display the total value for the grade letters.

Pls see the attached file for more clarity.

View 7 Replies
View Related
Feb 20, 2013

Here in "Grade" Column wants put a formula so that it will show First,Second,third and Fail. If the Mark is more than or equal 40 but less than 50 will reflect Third,if the mark is more than or equals to 50 and less than 60 will reflect Second, if the mark is more than or equals to 60 will reflect First and remaining less than 40 will reflect fail.

View 2 Replies
View Related
May 12, 2007

FromToGr Rate

90100A14.0

8689A23.6

8085B13.2

7279B23.0

6471B32.8

5663C12.6

This is part of a marks to grade and rating table. I have a list of students and the marks they obtained in an exam. I need a formula to put the grade and rate beside each name e.g. John; 92 marks; A1; 4.

View 9 Replies
View Related
Sep 15, 2014

I am trying to find lists of students from this worksheet who obtained the Grades in column K4, K12 and K19 together with their own classes. Is there any formula besides Pivot Tables to find them?

View 6 Replies
View Related
Nov 15, 2013

I am looking for a function that would convert any mark into a grade. For example in cell B4 I want to enter the total score, cell c4 the score that a student gets and in cell d4 the grade. It is like a grade calculator. I do not want to limit cell b4 the total score cell with a specific total score number. It can be 100, 50, 30 or 10. The moment I enter any total score and the mark that a student actually scored, the grade is given. I attached an excel sheet.

Marks and Grades Calculator.xlsxâ€Ž

View 12 Replies
View Related
Apr 6, 2007

I would like to prepare mid-term grades for my history class, and have three categories, which I would like to insert into a spreadsheet to calculate the grades, as follows:

Mid-term 1: 30%

Mid-term 2: 40%

essays: 30%

each of the three grades is a number from 1-100; the final answer will be a number which I can then convert to a letter grade.

I'm just not sure what function to use, in that last column, to get Excel to calculate the final answer/grade.

Let's just assume that Mid-term 1 is in column A; Mid-term 2 is in column B; and the essay grade is in column C. How can I create a function that will allow me to give the above percentages to the respective assignments, when calculating a grade?

View 9 Replies
View Related
Oct 28, 2008

I have a dataset (20,000rows) with Grade, Region and Salary. I need to calculate the 25, 50, 70 and 90 percentiles against each concatenated Grade and Region.

View 9 Replies
View Related
Jan 28, 2009

I have a problem with counting the number of students assigned to each professor and determining the number of students who have passing grade. Let say that the passing grade is 80.

View 9 Replies
View Related
Aug 28, 2006

I'm doing a course at the mo and get graded monthly. I have a spreadsheet with my grades on 'assignment1, grade A, assignment2, grade B and so on.

What i want to do is have a cell that has the aveage of all grades. So if i had...

Grade A

Grade B

Grade C

the average is B.

View 9 Replies
View Related
Jan 3, 2008

About conditional Formatting and relative referencing.

I need to change the colours of the cells depending if the pupil is meeting, over or under acheiving thier target grades.

I've got as far as highlighting the grades and using the formula in conditional formatting =ISTEXT(C7:C14) to display if the pupil is meeting their target grade.

I am aware that i will need to use relative referencing but am unsure how.

Its quite mind boggling to find out a way to see if they are over aceiving/under acheiving.

View 9 Replies
View Related
Jan 9, 2008

I have got students mark list in Excel. I want the grading as under in the last column.

73% and above = A+

63% to 72% = A

53% to 62% = B

44% to 52% = C

35% to 43% = D

30% to 34% = E

<30% = F

Is it possible with VBA?

View 8 Replies
View Related
May 21, 2014

I am trying to find a function to calculate the percentage grade as the semester progresses. I'm attaching an example of my sheet what I need is column "D" to show the grade percentage from columns "E"-"AK" as each grade is entered.

View 3 Replies
View Related
Aug 31, 2009

I would like to link students for the 1st Nine Week list to the correct grade level as shown. I have attached a file.

View 2 Replies
View Related
Jan 14, 2007

I would like to have a student's current overall grade be automatically calculated and displayed as I enter the test scores and extra credit points over the semester, first in percent and then in letter grade.

I have it set up so that the percent is calculated based on the total number of points likely to be obtainable at the end of the semester. But if they have only taken two tests and one extra credit assignment, it takes the total of those and divides it by the semester's total possible, instead of just the two tests and extra credit total possible. (ps: I do not know how many extra credit columns or number of possible points I will have this early in the semester)

Also, how then do I set up a formula to translate that percentage into a letter grade based on A=90-100, B=80-89, etc.?

View 7 Replies
View Related
Feb 10, 2014

I'm creating a Speech and Debate calculater that presents winners names by place according to their score. If you look at Tab HSSE Results it will read the inputed information from HS Speech English. I want the names of the students to appear in the correct ranking order in the respected grade rankings chart. I currently have a countif formula which reads the grade, but I think I need to link that with an index formula which I'm having problems with.

View 8 Replies
View Related
Jul 30, 2012

I have a custom range -55% to 55% as part of a grading system for sales growth. I want to return a 0-100% grade depending on where within that -55% to 55% range a sales reps growth for a month falls. For exaple, if a sales rep scores 0% growth for a month, they will receive a 50% grade by where 0% falls within the -55% to 55% range.

View 1 Replies
View Related
Nov 14, 2008

I have a decent working knowledge of excel, but I'm stuck... I teach and I have created an excel spread sheet to help me keep track of grades, attendance, etc.

I'm trying to figure out how to get excel to figure out the assignments a student has missing (cells with no data input), then take the assignment name (column title with missing data) and students name (first column of data) and put that information in another worksheet. Basically I would like excel to tell me what students are missing work and what assignments they are missing so I don't have to scroll through hundreds of lines of data whenever I have midterms or a student wants a list of "missing assignments". BTW---I can get it to list the number of assignments a student has missing, but not list the specific assignment titles.

I know theoretically this is possible, but I'm having trouble figuring out how to do it. Any help would be appreciated as it will save a lot of time and help out my students! If you can give me a "fake" formula, I should be able to update it for my purposes...

View 10 Replies
View Related
Jul 15, 2006

I have a very basic Excel Gradesheet that's designed to simply record letter grades, and show the grade average as the year progresses. I've hit a snag with problem in the formula which shows a grade of "F" - when the grade range can only be that shown on the table (A+ to E-). I've attached the Excel sheet so you can see what I mean.

View 8 Replies
View Related
Jul 10, 2014

When speaking with parents I want them to enter in their child's birthday i.e. 12/1/1998 in one cell and then automatically generate what grade they should be in the next cell. If the grade year cutoff date is Sept 1.

View 2 Replies
View Related
Oct 30, 2007

i'm trying to use HLookup to find an adjusted midterm grade that's given. but i have some conditions:

If student missed exam and has a zero – keep zero.

If student has a grade of 1-119 points, increase their grade 40 points.

If student has a grade of 120-125 points, increase their grade 35 points.

If student has a grade of 126-131 points, increase their grade 31 points.

If student has a grade of 132-139 points, increase their grade 27 points.

with these conditions, if my midterms grade is 120, how would i calculate it using HLookup? i worked on it but i keep getting the #NA! error.

=H4+HLOOKUP(H4,B24:D25,2).

View 5 Replies
View Related
Jan 26, 2010

I'm making my own gradebook (attached) and one of my sheets will list scores for each student in different assignments. I have one sheet which keeps track of all students and all assignments with other info. I would like to program cells in one sheet (the third in the attached file) to lookup a particular student's grade in a particular assignment. I figured trying a LOOKUP with an AND requirement might work but it keeps returning the message "could not find value".

My formula references the student's name and the assignment from the identifying cells so that it is easy to copy and paste. I wondered if it was this which resulted in the error, but doubt it.

View 4 Replies
View Related
Nov 5, 2013

I would like to change a number to a letter and then drop a digit from the end.

Say my data in A1 reads 81234568, and I would like it to display in cell A2 as h123456.

View 3 Replies
View Related
Sep 1, 2006

I am attempting to calculate Grade point averages for my students for all classes. There are 5 columns of grades to be considered. I frist assign values of 0-5 to the grades then average the points. My problem is that I want the AVERAGE to ignore the zero but it calculates it as well. (I enter a 0 if I have no grade for that class.) I have tried the{ } to make it an array formula but this also did not work. Here is what I have, can anyone help?

=SUM(AVERAGE(IF(AND(L2>89,L2<100),5,IF(AND(L2<90,L2>79),4,IF(AND(L2>69,L2<80),3,IF(AND(L2<70,L2>59), 2,IF(AND(L2>0,L2<60),1,0))))),IF(AND(T2>89,T2<100),5,IF(AND(T2<90,T2>79),4,IF(AND(T2>69,T2<80),3,IF( AND(T2<70,T2>59),2,IF(AND(T2>0,T2<60),1,0))))),IF(AND(AB2>89,AB2<100),5,IF(AND(AB2<90,AB2>79),4,IF(A ND(AB2>69,AB2<80),3,IF(AND(AB2<70,AB2>59),2,IF(AND(AB2>0,AB2<60),1,0))))),IF(AND(AJ2>89,AJ2<100),5,I F(AND(AJ2<90,AJ2>79),4,IF(AND(AJ2>69,AJ2<80),3,IF(AND(AJ2<70,AJ2>59),2,IF(AND(AJ2>0,AJ2<60),1,0))))) ,IF(AND(AR2>89,AR2<100),5,IF(AND(AR2<90,AR2>79),4,IF(AND(AR2>69,AR2<80),3,IF(AND(AR2<70,AR2>59),2,IF (AND(AR2>0,AR2<60),1,0)))))),-1)

I know it is huge. The syntax is correct. It calculates the average, but always for all 5 columns. It will not ignore a 0 in a column.

View 10 Replies
View Related
Jun 15, 2014

i need a formula for a sign in sheet for the academy i work at. we have night and day classes of the same sessions, in the planner they are listed as d1, d2 d3 and n1 n2 n3 and so on for each.

so basically im trying to create a formula to quickly ender the d1, d2, d3 ect into the cells on eachpage for the students to sign in for each day it works out to be about 190 calls and 9 diferent classes to you can see why id like to speed this up. problem is i need the number to change not the D and excel want to use the cell allocation.

as you can see from the document i have not attatched, i have created a formula to add in the dates automatically, i would like to do the same with the session numbers or the D numbers, this is one of the shorter courses and has about 190 days

View 4 Replies
View Related
Dec 30, 2009

i want to fill down a column and instead of my formula changing from A6 to A7 i want it to change to B6.

View 9 Replies
View Related
Jul 11, 2009

I want to apply Data Validation to a cell, so that only the following combination of letters and numbers can be entered.

Letter Letter Number Number Number Number Number Number Letter.

e.g AB123456C.

View 14 Replies
View Related
Mar 7, 2014

I need to change a few hundred cells (one column) where the first letter may be a capital letter to a lowercase letter.

So:

GetAwardfromBid to getAwardFromBid

or

SmallLertter to smallLetter

View 3 Replies
View Related
Apr 7, 2014

In sheet1 I have a simple database consisting of 5 columns of data

Column A : Name ie James Jones

Column B : payroll number ie 123456

Column C : shift times ie 1245-2124

Column D : job title ie floor

Column E : comments ie A/L or 0600-1500

what I would like is some code that will go down Column E and if a 'time string' ie 1300-2130 is found then copy this string and paste into corresponding value in column C. If a text string is found ie A/L or Sick or anything like this then ignore and move onto next cell, loop this until all cells in column E have been checked.

View 4 Replies
View Related
Sep 12, 2007

I need code to change a letter such as A into a column number i.e 1. Everything i can find is to do with changing column numbers into letters, surely you can do it the other weay round aswell? So when the macro is given the letter AA it returns the column number as 27 etc, but i need it as a defined variable such as "i = column number" so i can use this information further on in my code.

View 2 Replies
View Related