Convert Letter Grades To Numbers

Jun 21, 2007

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".

ADVERTISEMENT

How To Get Average Letter Grades

Jan 23, 2014

I am trying to average letter grades in a spresdsheet my formula seems to work, but if any of the columns in the spreadsheet are totally blank I get #DIV/0! in the cell where I should see the average grade. Is there anyway to stop this from happening. This is the formula I am using.

=CHAR(INT(SUM(IF(E21:E150<>"",CODE(E21:E150))/COUNTA(E21:E150)))) assay entered.

View 5 Replies View Related

Turning Grade % Into Letter Grades

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

Remove Trailing Letter From Numbers & Convert To Positive / Negative

Feb 16, 2008

I use currency data pasted from legacy program that pastes dollar values followed by a C or D to represent debit and credits, ie -- 1,000,000.00C or 1,000,000.00D.

Is there some way to remove the letter and correctly format the value to a negative or positive number on a whole worksheet or column?

Currently I am doing this manually one cell at a time.

View 6 Replies View Related

Convert Lower Letter To Capital Letter Automatically

Mar 2, 2009

When I type a single lower case letter into a cell, what formula or conditional formatting should I use to always convert it to a capital letter automatically?

View 9 Replies View Related

How To Sort Numbers With Letter Prefixes And Letters Mixed With Numbers

Jan 21, 2012

Using the following data

R10-12128
R11-12x12x8
R11-12x12x8
R1-12x12x8
R1-12x12x8
R12-12x12x8
R14-12x12x8
R16-12x12x8
R18-12x12x8
R2-12x12x8

I want it to sort like this:

R1-12x12x8
R1-12x12x8
R2-12x12x8
R10-12128
R11-12x12x8
R11-12x12x8
R12-12x12x8
R14-12x12x8
R16-12x12x8
R18-12x12x8

What is the formula to achieve this?

View 5 Replies View Related

Convert Letter To Number

Jul 23, 2009

Is there simple function that anyone knows of (or has written) that will convert a letter to its alpha-numeric equivalent?

For instance, A = 1, B = 2, AA = 27, etc (a = 1, b = 2, aa = 27)

View 6 Replies View Related

Convert Column Letter To Number

Nov 22, 2005

I need to convert a column letter to a column number for the following line of code in my VBA application:

VB:
strAverageBaseFormula = "=AVERAGE(D" & Trim(Str(lngFirstRowOfIncrement + 1)) & ":K" & Trim(Str(lngFirstRowOfIncrement + 1)) & ")"

I am inserting a formula into a cell using VBA, but the problem is that I don't know the letter value of column "K" (used in the middle of the line); instead, I know it as column number 11. Is there a simple way to convert the column number 11 to the column letter "K"?

View 9 Replies View Related

Convert Format To M Into Just Gives Me First Letter Of Month

Jan 20, 2009

How Do I Convert Date:

10/3/2008 into October
6/1/2008 into June
7/3/2008 into July

I have date 10/3/2008 in cell and if I convert format to M into Just gives me first letter of Month, so O, I want it to read October, etc.

View 2 Replies View Related

Convert Column Letter To Number

Nov 13, 2006

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?

View 9 Replies View Related

Convert Column Number To Letter

Jan 17, 2004

I can obtain the columns numbers but I cannot get the letters. Is there anyway to convert from a number to a letter?

eg. somefunction(1) gives me column(A) as an answer?

View 9 Replies View Related

Method To Convert Column Number To Letter

Sep 15, 2014

I wanted to know if there was a way to either make a variable hold a column letter or else automatically convert a column number to a letter. This would be for use in the Range property.

All I could find is some complicated technique requiring division by 26 that I will never remember let alone code quickly.

Or if you have a variable holding a column number, is the only way to use it with Cells?

View 5 Replies View Related

Dropdown Menu - Convert Letter To Number

Sep 4, 2013

I have a drop down menu using data validation and the values are B,C,D

I want to keep the letter in a cell, but make each one become number, so B=5, C=10, D=20

I have another dropo down menu that contains 6,10,16

What I require is that once the 2 drop down menus have 'values selected' I need to multiply the 2 cells together

so for example

If B and 6 was selected, I require the 3rd cell to be 5*6 so what is the formula?

View 1 Replies View Related

Convert Column Number To Letter From A Range Objec

Jul 7, 2009

Is there an easy way (without writing my own conversion function) to get the column letter from a range object, as opposed to the column number?

View 5 Replies View Related

Convert First Letter Of String To Capital Without Altering Formatting

Nov 17, 2009

Convert the first letter of a string to a capital without altering the rest of the strings format.

example: the activecell contains the string a1st (lowercase a, superscript 1st)

how can i achieve this in VBA?

Additionally, is it also possible to convert all of a string to capitals except the superscript characters

View 9 Replies View Related

How To Add And Subtract Using Letter And Numbers

Feb 9, 2014

I am looking to be able to compare a number with a letter so for example 4c and compare it with another 5c and in that scenario see a difference of 1 but when the two to be compared are 4c and 4a it would see 0.6.

in this excersize

A=0.33333R
B=0.33333R
C=0.33333R

it is basically sub category of the initial number so an A is better than a B and in tern a B is better than a C

for example

Targeted Working At Residual
4c 4b 0.33333r
5a 4c -0.33333r
4c 5c 1
4c 5a 0.33333r
5c 3b -1.66666

so on and such forth the number and letter can be entered into seperate fields the lettering are only A,B,C but numbers can range from 1-9 i am normally quite ept with excel but this is out of my depth

View 4 Replies View Related

Letter Association With Numbers

May 21, 2009

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.

View 9 Replies View Related

Add Cells With Letter & Numbers In The Cell

Jul 30, 2008

I'am trying to add a row of cell that contain a letter befor the number
I need to add-up the numbers and ignore the letter

View 12 Replies View Related

Extract Numbers And Prefix Letter

Aug 21, 2009

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.

View 9 Replies View Related

Formula - To Obtain The Last Two Numbers Before The Letter B

Jan 25, 2009

how it would be possible to obtain the last two numbers before the letter B, if "Fri Aug 01 16:40:49 BST 2008" is placed in A1 so "49" would be placed in B1,

View 9 Replies View Related

Convert Numbers Stored As Text To Numbers (attached File)

Oct 22, 2009

In the ID column of the attached excel file whenever I convert the numbers stored as text to numbers it results in a weird transformation.

e.g. an ID of 480610141001 becomes 4.8061E+11. When I do the same process in the name column, which has similar numbers, it will give the correct result following the same process.

View 2 Replies View Related

Check For Letter In Range & Count Numbers

Aug 13, 2008

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
Employee 2E0
Employee 3E0
Employee 4E0
Trip 2Employee 1758
Employee 20
Employee 30
Employee 40
Employee 50
Employee 60
Employee 70
Employee 80
Employee 9E0
Employee 10E0

View 2 Replies View Related

Macro To Convert Numbers Stored As Text To Numbers?

May 23, 2014

I have been looking through the forums and found the below code, but I have both text and numbers in the same range. I have attached an example of what I need to have converted.

Book1.xlsx

View 3 Replies View Related

Convert Downloaded Web Page Numbers Seen As Text To Numbers

Jan 16, 2008

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?

View 5 Replies View Related

Insert A Letter Or A Number In Front Of Numbers In A Cell

Oct 3, 2008

Need a function that would insert a letter or a number in front of numbers in a cell for example

column A
3245

I want to insert the prefix "S" in front of the nummbers 3245. so i would hopefully end up with

Column A
S3245

View 3 Replies View Related

Convert Numbers, Seen As Text, To True Numbers

Aug 26, 2006

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.

Sub CleanData()
Application. ScreenUpdating = False
' Find the Right most cell and the Bottom most cell and
' run the macro from A1 to this cell recursively
Range("IV1").End(xlToLeft).Select
Col = Selection.Column
Range("A65536").End(xlUp).Select
Row = Selection.Row
Range("A2").Select
Range("A1", Cells(Row, Col)).Select
Application.Run ("FixTextAsNumberError")
Application.ScreenUpdating = True
'
End Sub..............

View 5 Replies View Related

Convert Numbers As Text To True Numbers

Sep 29, 2007

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
Else

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?

View 3 Replies View Related

Convert Numbers Seen As Text To True Numbers

Nov 21, 2007

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

View 4 Replies View Related

Excel 2007 :: How To Remove Letter And Leave Numbers And Chinese Characters

Mar 19, 2013

I need a formula to use on MS Excel 2007 to remove the English letters from a cell A1 and return only the numbers(if any) & Chinese characters to B1.

Please refer to the able below.

Example:

A
B

1
so l首先欢迎大家收听我们的科学与烹饪系列
首先欢迎大家收听我们的科学与烹饪系列

2
讲座的最后一次报告 有点难过这是最后一次了
讲座的最后一次报告 有点难过这是最后一次了

[Code]...

View 7 Replies View Related

Convert Column Number To Column Letter

Nov 20, 2009

in a macro i have this: col=cell.column 'suppose col=16384. then i need to place in a cell this formula =(XFD2708*100/XFD2597)-100 so i'm looking for "something" that can convert 16384 in XFD.

View 2 Replies View Related

Return Column Letter Based On The Letter In A Cell.

Dec 31, 2009

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.

=IF(INDEX('Overs-Unders'!B:B,MATCH($C145,'Overs-Unders'!$A:$A,0))"",INDEX('Overs-Unders'!B:B,MATCH($C145,'Overs-Unders'!$A:$A,0)),"")

View 9 Replies View Related

Convert To Numbers

Sep 16, 2009

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

View 9 Replies View Related

Convert Numbers

May 11, 2006

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.

View 6 Replies View Related

Change Letter Case Of Cells First Letter Only?

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

How To Count Only 10 Out Of 18 Grades

Jun 24, 2014

I have a work problem that I'm not sure which functions to use. I'm creating a grade calculator...here is the problem:

I have 18 total lessons (cells A1:A18). Each lesson is worth either 3 points or 0 points. Of the 18 lessons, only 10 count towards my grade. What functions do I use to count only 10? the countif function? Do I use a nested IF?

remember that of the 18 lessons, only 10 (any 10, not just the first 10) count.

View 2 Replies View Related

Checking A Row To See Who Got All A Grades

Aug 15, 2007

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=
ABCDEFGHIJKLMNOPQRSTUVWXYZ1ArtArt*2BiologyBSChemistryD&TDramaEconomicsE.*LitFrenchGeographyHistoryH.*EconICTICT2IrishLatinMathematicsMaths*PureMusicPhysicsPoliticsPsychologyR.ESociologySpanish2********A****A**********A*3********AA*A*******A******4******A*C*****D****B******5***********B**********BAA*6*******C***D************BBSheet1*
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

View 9 Replies View Related

Summing Of Grades

Sep 16, 2009

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.

View 9 Replies View Related

Grades And Conditions

Oct 6, 2009

I have few grades and conditions on which rate will populate in the D1 cell.

Tried at bit
=IF(OR(A1="x10",A1="x20"),"150",IF(A1="x30","240",IF(A1="x40","190",IF(A1="x60","340","50"))))

GradeConditionsRates
x10offshore150
x10Onsite320
x20offshore150
x20High Skill170
x20Onsite320

View 9 Replies View Related

How To Convert Numbers To Letters

Apr 5, 2007

i want to convert numbers to letters in the excel Sheet
I.E: when the number is 1000.00$ it write in another cell
on thousand dollar only

1500.00$ one thousand five hundred dollar only

View 13 Replies View Related

Convert Words Into Numbers

Aug 31, 2009

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?

View 9 Replies View Related

Convert Whole Numbers To Percentages In Vba

Jun 18, 2014

I have a sheet that shows me in column I, J , K whole numbers eg. 25 , 50 , 25

I would like to format this to percentages eg. 25%, 50%, 25%

The number of rows can grow as well.

View 6 Replies View Related

ADVERTISEMENT