Change Letter Grade To Number Grade
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 Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
IF THEN Statements: Assign A Letter Grade To A Number
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 Replies!
View Related
Calculate Final Grade Based On Grade Table
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 Replies!
View Related
Turning Grade % Into Letter Grades
creating a function to turn a percent (0100) 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 howtos. I created two columns, one with what the grade entails (93100 , 9093 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 Replies!
View Related
Assign Consistent Letter Value To Grade Percentage
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 Replies!
View Related
Converting A Numeric Cell To A Letter Grade
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 Replies!
View Related
Entering A Formula To Determine A Grade
I would like to prepare midterm grades for my history class, and have three categories, which I would like to insert into a spreadsheet to calculate the grades, as follows: Midterm 1: 30% Midterm 2: 40% essays: 30% each of the three grades is a number from 1100; 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 Midterm 1 is in column A; Midterm 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 Replies!
View Related
Conditional Formatting Grade Letters
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 Replies!
View Related
Formula To Show Current Grade Of Student
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=90100, B=8089, etc.?
View Replies!
View Related
Making A Grade Book Missing Assignments Formula
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". BTWI 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 Replies!
View Related
Formula Show The Grade Average As The Year Progresses
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 Replies!
View Related
LOOKUP With AND Requirements (lookup A Particular Student's Grade In A Particular Assignment)
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 Replies!
View Related
HLOOKUP; HLookup To Find An Adjusted Midterm Grade
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 1119 points, increase their grade 40 points. If student has a grade of 120125 points, increase their grade 35 points. If student has a grade of 126131 points, increase their grade 31 points. If student has a grade of 132139 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 Replies!
View Related
Grade Point Average Using AVERAGE IF AND
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 05 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 Replies!
View Related
Change Column Letter Into A Column Number
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 Replies!
View Related
Change And Show Letter With F9 Or Random Or Any Formula
I just want to show a letter and change it to any letter and show it again in seconds. Can it be done with formula, maybe with RAND formula or any other formula. for example when i press F9 the letter A change B, and then i press F9, it changed to C, and then when i press F9 and it changed to A again, and i press F9 and it changed to B, and so on... (Is it possible too..with a little variation if i press F9 continually, it changed every 5 second?)
View Replies!
View Related
Change Unc Links To Drive Letter Mapping
I have a user whose links in his spreadsheets are in UNC format. He changes them to drive letter mappings, but when he opens the workbook again, the UNC format returns. how to change the links so that they remain as F: etc.. rather than \servernamesharename The user has MS Excel 2000 and Windows Xp Professional
View Replies!
View Related
Change Target To Full Text Based On Letter
how to allow both these codes to work on say sheet 1. I can get one to work just fine. So, any tips on how to get them both to work on the same sheet would be great. Private Sub Worksheet_Activate() End Sub Private Sub Worksheet_Change(ByVal Target As Excel. Range) With Worksheets("Sheet1") If Not Application.Intersect(Target, .Range("n1:n200")) Is Nothing Then If Target = "S" Or Target = "s" Then Target = "Submitted" If Target = "A" Or Target = "a" Then Target = "Approved" If Target = "I" Or Target = "i" Then Target = "Investgating" Else End If End With End Sub and this,.............
View Replies!
View Related
Number Of Occurrences Of Each Letter
I need to figure out the number of occurrance of a letter in a word written in a cell. For Example i am writing "pattern" in a Excel cell. I want to know the marco/vba code that will give me the number of occurrance of each letter. The output should be: p=1 a=1 t=2 e=1 r=1 n=1
View Replies!
View Related
Column Letter Instead Of Number
is there a way to make the following code return the letter of the column instead of the number? currently if the 'String' value that is in 'ColumnFind' is in column B this code returns a value of 2. i Need the 'B' for later code to work. ColumnLetter = ColumnFind.Column
View Replies!
View Related
Convert Column Letter To Number
Some bits of code I have learned use column numbers and some bits use column letters. Can someone share a line or two that I could add to my macro that will convert the F representing column F into a 6, and vice versa, so that I can continue using my preexisting bits?
View Replies!
View Related
Knowing The Worksheet Number Or Letter
Without using VBA code, is there a way to display or find the worksheet number of the active worksheet you are viewing? All my sheets have names, and I have a lot of them. When I want to loop through a set of them with code, I want to know what numbers they are beforehand.
View Replies!
View Related
Exchange A Number For A Letter Forumla
I have a sheet which calculates payment amounts. Column titles: Hours  Rate of Pay  Total In the hours column usually the entries consist of numbers and everything works fine. However when an employee is on holiday they are still paid. What I want to do is be able to enter the letter "H" for one of the entries in the hours column. The sheet to translate this as 2 hours. H=2 x rate of pay = total I cannot for the life of me get the correct formula to in order to achieve this. I don't particularly want to use a macro for this and others have suggested the "COUNTIF" function.
View Replies!
View Related
Sorting Number/letter Combos
I have a spreadsheet with information in columns ax. In column A there are part numbers like: RH63034, PH630343, 6255, 1601, 72500, There are may combinations of just numbers, and numbers first letters second, and letter first number second. All usually seperated by a hyphen. The entire spreadsheet will be sorted by Column A first. I need to sort them so the order would be numbers first and combo with number letters next. finish product: 6255, 1601, 72500, PH630343, RH63034. Is this possible? I have seen other posts and suggesting putting spaces before the numbers. That seems to work but in the case of 6138 and 61038 the 61038 is first
View Replies!
View Related
Check If Character Is A Letter Or A Number
I have a cell range that is passed as a String to a function, and within that function I need to extract only the Column letter. If it was just 1 letter it would be simple, but it may be 2, so does anybody know of a way of testing to see if the second character is a letter or a number?
View Replies!
View Related
How To Output Column Letter (not Number) With A Formula
Is there a function that will output the column letter? For example there's one I know of: =COLUMN(), which outputs column number, but not the letter. And if not, can a formula be written to output it without converting the spreadsheet to R1C1 style or using the lookup function that refers to a separate table within the spreadsheet?
View Replies!
View Related
How To Find Any Number Greater Then (x) And Replace With A Letter
how I could search for any number great then (x) and replace it a letter For example I have an excel table with a series of weights. lbs 6001 4560 6789 2000 5656 8879 1243 I like to replace any number greater or equal to 6001 lbs with the letters SS. Example: lbs SS 4560 SS 2000 5656 SS 1243 Then I'd like do the same thing again but this time replace any number less then or equal to 6000 lbs with the letters SSLL . Example lbs SS SSLL SS SSLL SSLL SS SSLL
View Replies!
View Related
