Convert Letter Grades To Numbers
a formula that would take letter grades (A, B, C, D, and E) and produce an average letter grade?
For example, a student gets a D on one assignment and a B on another. I want a formula that will produce "C".
View Complete Thread with Replies
Related Forum Messages:
Turning Grade % Into Letter Grades
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.
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 pre-existing bits?
Letter Association With Numbers
On column "F" I have all the names listed, they are all lowercase, and with different length. How do I write a formula to turn those names into numbers?
For an example. In column F1 I have "James". And using letters = numbers
9 = A L T
8 = B N W
7 = E P X
6 = G R Y
5 = I J
4 = H S
3 = F Q Z
2 = D O U
1 = C M V
I would like the column G1 to display "59174"?
Would need the convention from letters to numbers on Column G adjacent with the name.
Convert Downloaded Web Page Numbers Seen As Text To Numbers
See attached file. A colleague is downloading rows of data from a website which contains a number field Excel is currently treating as Text after being pasted in. My spreadsheet includes just a sample of the many rows of data however as you can see the VALUE function refuses to convert these text values to numbers. How these might be converted and why the VALUE function refuses to work in this case?
Extract Numbers And Prefix Letter
I need to extract (and then use for SumIfs) only item numbers from the long description. Please see the attached list where item number column shows existing list & next column shows what i want to extract. The exrtacted part if has any trailing or succeeding letters, characters between numbers should stay. for example from "SGA:RV-SVA:PEPPERS/PEPPERONCINI:SV9176001/232034" I need to extract " SV9176001/232034" or from " SPICES:BULK SPICES 7100:9054B" I need to extract " 7100:9054B". Can some one please urgently help me on this.
Check For Letter In Range & Count Numbers
I need to compare for each trip whether there is a trip with Es and no Es in it and mark every line in column E with tag "Mixed Use". In the data below trip 2 has mixed use. I have attached a sample file.
Trip Employee EntertainmentMiles
Trip 1Employee 1E827
Trip 2Employee 1758
Convert Numbers As Text To True Numbers
I have the following two macros that I use daily:
Public Sub add_tick_marks()
Dim c As Range
For Each c In Selection
If Not IsError(c.Value) Then
If Left(c.Value, 1) <> "'" And c.Value <> "" Then
If InStr(c.Value, "E+") > 0 Then
c.Value = "'" & c.Formula
I use these because I frequently copy billing account numbers that have leading zeros from some proprietary software and work with them in Excel. I need the leading zeros to facilitate VLookUp's. When I paste the data into Excel it truncates the leading zeros. My typical procedure is:
1. Copy a column of values from our proprietary software
2. Paste it in Excel (Ctrl+V)
3. While newly pasted data is still selected I hit Ctrl+1 which brings up the Format Cells form.
4. I double click "Text"
5. I re-paste into Excel (Ctrl+V)
6. I run my macro to add tic marks to the values so the leading zeros never get lost.
The problem occurs when I copy multiple columns of data and paste it in Excel. If one of the columns of data contains numbers or currency then I select that range of values and run the macro to get rid of the tic marks. After running the macro the numbers are still treated as text. When I select a range of those values and right-click on the status bar and select " Sum" there is no value. No big deal, I just highlight them and format the cells as numbers or currency. But after formatting them as numbers or currency, they retain their format as text until I click in the formula bar for each individual cell and hit enter, at which time they take on the number or currency format I have chosen and the sum can then be displayed in the status bar.
How can I force the formatting I chose to take effect on the data immediately without me having to individually "fake change" the data in each cell?
Convert Numbers Seen As Text To True Numbers
I have text as numbers downloaded to excel sheets from crystal that i need to add together on a summary sheet. I've tried using Value, TRIM and CLEAN functions to no avail. the TYPE function is reading the cell as Text and I have also tried multiplying by 1. Does anybody know how I can get around this ? hopefully I've attached an extract of the file
Convert Numbers, Seen As Text, To True Numbers
The back story is that from a system we use, when you download data from inside it, Excel treats most of the cells with a "Number Stored As Text" error. I had problems with this and it was just generally annoying so I wrote the below macro that converts each of the cells back to general cells and reinputs the data, essentially reseting the cell and keeping the data. Being that this is a loop, it takes a good while to run if alot of data was downloaded. Any idea's on how to speed it up besides screen updating? Note, other stuff happens in the first macro, but it is just cosmetic non-intensive things. It calls the second macro because I wanted them seperate should I want to just run the second.
Application. ScreenUpdating = False
' Find the Right most cell and the Bottom most cell and
' run the macro from A1 to this cell recursively
Col = Selection.Column
Row = Selection.Row
Range("A1", Cells(Row, Col)).Select
Application.ScreenUpdating = True
Convert To Numbers
I have a workbook full of six digit numbers that I need to manipulate but can't. They have been data-dumped from a server and copied as non-numeric values.
I have tried EVERYTHING I could find on how to convert these column cells to numeric fields:
Multiplying by 1 - didn't work
VBA Code - For Each xCell In Range("a1:a1012")
xCell.Value = xCell.Value
Next xCell -didn't work
Format Cells as numbers - didn't work
Format Cells as general - didn't work
Remove Spaces - didn't work
Text to Columns - didn't work
This is how the data is stored.
000216 000703 000744 000819 002184 002529 002571 002573 002783 003222 003645 003826 004034
I need to create a formula to convert the number into millions. I want to do this in the format cell >> Custom in the excel sheet.
Suppose the number is 2000000 the it should show as 2.
Return Column Letter Based On The Letter In A Cell.
For the below formula is it possible to replace the B's (column location) with a cell Say Z146 which contains the letter B (or a number if thats easier and someone can tell me the numbers for each column).
When the formula is dragged into the next cell (down) it takes its column reference from Z147 and then my life becomes so much easier.
Convert Words Into Numbers
For my research in medicine I build a spreadsheet with google docs. After having received most of the data I transfered the spreadsheet into an excel file. The next thing I would like to do is to convert the words in the spreadsheet into numbers so I can calculate with them. For example: every row in column E consist of one of the two words: 'man' or 'woman'. I would like to convert the word 'man' into a '0' and the word 'woman' into a '1'. Is it possible to write a formula or function for this?
Convert Numbers As Text
Working with an inherited spreadsheet which has massive amounts of numbers formatted $US to 2 decimals. Can't manipulate the data: all formulas to sum groups of the numbers yield zero and formulas to multiply or divide them yield "#VALUE" error message. I guess the data is text (is left justified) although there's no apostrophe visible in the formula bar. Anybody know how I can convert these to numbers?
Convert Numbers To Text
converting numbers to text:
In cell F39 i have a number (for example) 4322.08
and i would like to convert into into text in the following way
In cell B47 I would like it to say Four
In cell C47 I would like it to say Three
In cell E47 I would like it to say Two
In cell G47 I would like it to say Two
In cell I47 I would like it to say Two
in cell J47 I would like it to say Eight
But essentially any number that I type into cell F39, I would like it to convert the number to text
Convert Negative Numbers To Zero
In an excel column listing monthly payments, I cannot report a negative value . I need to "carry forward" the negative value by automatically adding it to the next positive cell in the column. This process should loop through the column leaving no negative numbers, leaving a zero in any cell where the negative number was originally and balance out to be the same amount as the sum of the original listing of monthly payments.
Convert Numbers To Times
I have a workbook that has many linked cells and formulas. Some of the times were entered manually in hh:mm format and are located on tables that are used to get a number from. On another worksheet, there are times taken from the internet that show up in general format. So 00:05 shows up as 5. I have tried to change these into number formats but it always shows up as 00:00 and tries to include the date in the formula bar.
These various cells are linked and are used to look up other values but the formats are different and not talking. I am looking for a way to get them to work with eachother without using formulas if possible because many of the cells already have formulas in them.
Convert Standard Numbers To Time
Is it possible to convert the following data to an Excel-recognized time format (easily, as I have numerous million-row files with time data like this). Some actual data is below with what it should be in parentheses.
Convert Numbers To Single Letters
In row G, I have a wide range of values from -3000 up to 2500.
These values are generated from a formula. =A5-B5.
I need a script that will scan row G between G5:G500 and give them a letter value.
Convert anything less than 0 to an A
Convert anything equal to 0 or equal to 1 to a B
Convert anything between 2 and 7 to a C
Convert anything greater than 7 to a D
It can place the new categorized letter value over the original formula in row G or put the letter value right next to it in H.
Convert Positive Numbers To Negative
I have created a Pivot table from a source data file that includes a document status column ('Type I Or C') (I for Invoice & C for Credit) and an Invoice / Credit value column (Invoiced Price). However the values for both invoices and credits are positive so when summed distort the total values.
I am attempting to create an additional column within the Pivot table to convert the credit note values to negative by inserting a calculated field under the formula tab, i.e.
=IF('Type I Or C'="C",-'Invoiced Price','Invoiced Price')
The above formula works fine in a standard worksheet but it is not reckonsing the "C" within the pivot table. If I manually change the value to numeric (i.e. 1 for Invoices and 2 for credits) it works fine, i.e =IF('Type I Or C'="2",-'Invoiced Price','Invoiced Price')
so it appears to be an alpha issue?
Convert 4 Digit Numbers To Times
Is there any way changing general four digit number into hours and minutes?
I have almost 31000 rows of imported data, showing arrival and departure times with four digits (dep 2130, arr 0130) without colons and I need to subtract dep from arr to get block hours. Is there a way to add colon to multiple cells or some other solution to my problem?
Adding colon to 62000 cells one by one does not sound that good to me.
Grades And Conditions
I have few grades and conditions on which rate will populate in the D1 cell.
Tried at bit
Summing Of Grades
I have a list of students who achieve grades A-G in subjects and I have organised these into columns. I then need to be able to be able to count a total of how many grades they have achieved, how many As, Bs etc. So far I have managed this but...I need to be able to attach different values to the grades. Some subjects are worth 0.5, some 1 and some 2. I cannot work out how to count if they achieve a grade A worth 0.5 + a grade B worth 1 etc.
Checking A Row To See Who Got All A Grades
I've got all the grades sorted out for the Principal, she is now looking for me to tally up all the students who got straight 'A' grades. I know there is going to be anotehr combination here but I'll start with the basics of straight 'A's
The screen below shows how the data is presented although I've slimmed down the headings to fit better.
How do I insert a formula to look at each row to see where based on the subjects taken, there are straight 'A's
************************************************************************>Microsoft Excel - Y13 & 14 Combined Worksheet.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutZ6=
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
Cannot Convert Numbers Stored As Text To Number Format
There is probably a really easy answer to this question but I cannot seem to figure it out. I need to calculate the sum of pages faxed on a fax report at my office on an excel spreadsheet which is downloaded from our server. It appears the file is not meant to be used in excel but it downloads as an "*.xls" file anyway. When I open the file I receive this message:
"The file you are trying to open, 'FaxCetailReport.xls', is in a different format then specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?"
The file is comnig from a trusted source so I select "Yes" and it opens just fine. There are just over 50 rows of info, one of them being the number of pages. In a blank cell I enter "=SUM(select rows)" and the result is a "0". I have converted the cells to the "number" format, no change. When I right click on the cells and select format, the protection tab on the right has the check box "Locked" checked and unchecking it does nothing, it is checked as soon as you go back in to the protection tab.
The only way around this is to manually retype the numbers in a cell next to the pages column, which is ok for 50 numbers, but I have some sheets where there is over 1,000 entries.
Convert Imported Values, Being Seen As Text, To True Numbers
I have a document passed to me that includes information pulled from an internal system.
I want to use some basic formulas to show Totals, averages etc.
However, the SUM function does not work on the data provided unless I select the cell (As if to edit the text) and the press enter.
Is there a quicker way of selecting all of the cells in Column A for example and performing this function on mass, rather than selecting each cell individually.
I have attahced a similar sample copy - My SUM formula is show in cell B15.
Cstr Function: Convert A Range Of Numbers To Text
i am trying to convert a range of numbers to text using the Cstr function ,it doesnt work. excel VBA help states that CStr function converts a numeric value to a String. i am aware that i can convert a number by preceding it with an apostrophe
i just need to know why Cstr doesnt do the job
For Each rng In Selection.Cells
rng = CStr(rng.Value)
Macro To Convert Numbers To Alphabet Letters & Sum Range
First my goal is to sum a row and column. For example i want the sum of row 1 a to row 1 g. However, I'm using a loop for an automated macro. So i want to be able to say something like cells(1, count), so during the loop count goes from 1 to 7 representing the letters in the alphabet. But I'm not sure how to do so.
Secound, in my vba script to pull information from specific pages i say "sheet1.activate" how can i had the sheet switching during the process to speed up the calculation? and last but not least,
If Cells(1, locd) = "2008" Then
When i run my script, i get a runtime error 1004 application-defined or object defined error. The weird thing is, i can move what line it is on and then the macro will run ONCE and then it breaks again with the same error for that specific piece of code.
Transposing Grades In New Sheet
I have an excel spreadsheet with my students' grades on it. I want to be able to click on a student's name and have a list of all the assignments, along with only that student's corresponding grades, transposed on a new sheet so that I can print out to give to a parent.
Weighted Average With Grades.
I am having trouble coming up with a formula to calculate the weighted average of students Finals grades. This is the format my sheet is in to give u an idea.
Test # 1 Test # 2Test #3Assignment #1Assignment #2Final Test Final MarkPossible Points:1001001001010100Percent Worth:20%20%20%5%5%30%Students:Anderson, Ken6473788768 ?Carter, Bill72768473.587 ?Dubeers, Ashley84887610590Jackson, Kevin7666549873Parker, Jerome82657679.560Remini, Leah969290101089Thompson, Chuck5042806.5760Vaughn, Sarah7265658970
I have to come up with students averages based on the mark, the percent each grade is worth and the maximum amount of points its worth. Anyone know the formula or how to calculate the final grade using all of these factors?
Weighted Average Of Grades
I am in need of some more assistance regarding finding out a formula to find out the average grade of a pupil which ranges from letters 'A to E. This maybe be a simple task for experts, but unfortunatley spreadsheets are not my strong point. D7:D14 is the coloum that i wish to have an average of the grades acheived by each individual pupil in thier correspongin rows (on the right hand side of D7:D14) http://i41.photobucket.com/albums/e2...2/example2.jpg
Convert Numbers To Postitive/Negative Based On Column Header
I have this data source file that comes from a back office program, and basically what i want it to do is to turn the number negative in column C when the header of that column in column A is WITHDR and leave it positive when it is CONTR. What i was thinking was that it could go to column A from column C and go up each cell until the cell is not a date and multiply the column C number by -1 depending the column A header equals WITHDR and do that for every cell in column C, but I dont know how to proceed, im new at VBA.