Free Microsoft Excel 2013
Quick Reference
Free Microsoft 2013 Quick Reference Guide

Free Microsoft Excel 2013 Quick Reference

Convert Letter Grades To Numbers `

Can anyone suggest 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".

Thanks!


Post your answer or comment

comments powered by Disqus
I am using VLOOKUP to convert letter grades to numerical grades. I need to
avoid generating #N/A and just have a blank cell when a cell does not contain
a letter grade; e.g.

Letter Grade Column Returned Numercial Grade
A 1
B 2
(At the moment using VLOOKUP
generates #N/A
E 5

Many thanks

I am working on a spreadsheet in Excel for Grades for my students. I need to
set letter grades to numeric equivalents (A = 4.0, A- = 3.7, etc) then have
the final grade show up as a Letter (A, A-, B+, etc.) Part II of this is I
have 9 grades each equal to a certain % of the Final grade (totaling
100%).... Help! Thanks Angelo D

Can anyone suggest 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".

Thanks!

I have an excel spreadsheet filled with numbers (i.e. a 10x10 excel sheet grid) and want to convert the numbers to letters. I want to map from 1-26 all the letters of the English alphabet. So 1=A, 2=B, 3=C, ...26=Z. I am a novice with excel and I know how to do some basic SUM formulas, but that is about it. Can someone point me in the right direction on how to convert this sheet or how to create a macro that can convert this sheet for me? I saw other posts that talk about converting letter grades to numbers then taking the average, etc, but I need to do the opposite. Any help? I am attaching a spreadsheet as an example that I am trying to convert from numbers to letters...

Thanks,
---MC

Hi !

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

Thanks.

Is there a way to represent the number of characters in a cell as a number.

e.g. if "****" (not including the quotes) appears in cell A1, can you represent that as the number 4 in cell A1?

I'm familiar with =LEN(A1), but that requires presenting it in a different cell. I'm attempting to convert character count to number in same cell. Thanks for any help.

I have a column that contains times in military format. I want to convert the times to numbers, with no formatting.

For example:

Right now the columns show the following:

0:01
0:23
2:14
13:32
19:54

Their actual values are:

12:01:00 AM
12:23:00 AM
2:14:00 AM
1:32:00 PM
7:54:00 PM

I want it to instead have the following values:

1
23
214
1332
1954

They should be formatted as numbers, with no indication that they represent times.

Is this possible?

I have a worksheet that contains military times in number format that I need to compare against.

Thanks.

Hi, guys,

I am trying to create a spreadsheet that can calculate my GPA. I have
column B be the number of credit and column C be the letter grade I can
enter from F to A+. Now, I want column D to be the grade point, which is
converted from column C. For example, when I enter A in C1, I want D1 to
be filled with 4 automatically; when I enter B+ in C2, D2 should be
3.33, and so forth. How can I do this? I tried using LOOKUP function
but no luck. Any idea? Thanks.

--
scabbage
------------------------------------------------------------------------
scabbage's Profile: http://www.excelforum.com/member.php...o&userid=28275
View this thread: http://www.excelforum.com/showthread...hreadid=478416

Hi, guys,

I am trying to create a spreadsheet that can calculate my GPA. I have column B be the number of credit and column C be the letter grade I can enter from F to A+. Now, I want column D to be the grade point, which is converted from column C. For example, when I enter A in C1, I want D1 to be filled with 4 automatically; when I enter B+ in C2, D2 should be 3.33, and so forth. How can I do this? I tried using LOOKUP function but no luck. Any idea? Thanks.

I am a teacher trying to figure out how to assign a numerical value to a
letter grade. I have created the gradebook for this but I am stuck with the
formulas (or even if it is possible to do this). I have the formula to assign
a letter grade based on the numeric values entered [the formula I am using
is:
=IF(O7>84.5%,"HD",IF(O7>74.5%,"D",IF(O7>64.5%,"C", IF(O7>49.5%,"P",IF(O7>39.5%,"PC",IF(O7>=0%,"F")))) ))]
Because of the complexity of the assessment criteria sheet it is easier to
assign a letter grade than a numeric value, however to get the final grade I
need a numeric value.

Based on the following is it possible to create a formula for Excel 2003
that will assign a number to a cell when a letter is entered in another cell.

eg. if a HD+ = 5 points, HD = 4.5 points, HD = 4 points etc and I enter HD+
in say cell A2 and want the numeric grade to appear in cell F2 what formula
would I need to enter in cell F2 to get the numeric grade so that it could be
added with other numeric grades in the criterion to award a final grade for
the criterion. Some criteria have 3 sub criteria and a student might get a
HD, C and P- and the final grade would be the result of the three numeric
values added together and then included with the other criteria in other
sections.

Also is there a formula that can be used to only assign a final grade to a
cell in the event that all other relevent cells have a grade assigned in
them? for example if a student fails to submit and assessment item I do not
want to assign a final grade. Can Excel 2003 stop the final grade cell being
completed based on a formula in the cell?

Thank you very much for your help with this.

I am a teacher trying to figure out how to assign a numerical value to a
letter grade. I have created the gradebook for this but I am stuck with the
formulas (or even if it is possible to do this). I have the formula to assign
a letter grade based on the numeric values entered [the formula I am using
is:
=IF(O7>84.5%,"HD",IF(O7>74.5%,"D",IF(O7>64.5%,"C",IF(O7>49.5%,"P",IF(O7>39.5%,"PC",IF(O7>=0%,"F")))) ))]
Because of the complexity of the assessment criteria sheet it is easier to
assign a letter grade than a numeric value, however to get the final grade I
need a numeric value.

Based on the following is it possible to create a formula for Excel 2003
that will assign a number to a cell when a letter is entered in another cell.

eg. if a HD+ = 5 points, HD = 4.5 points, HD = 4 points etc and I enter HD+
in say cell A2 and want the numeric grade to appear in cell F2 what formula
would I need to enter in cell F2 to get the numeric grade so that it could be
added with other numeric grades in the criterion to award a final grade for
the criterion. Some criteria have 3 sub criteria and a student might get a
HD, C and P- and the final grade would be the result of the three numeric
values added together and then included with the other criteria in other
sections.

Also is there a formula that can be used to only assign a final grade to a
cell in the event that all other relevent cells have a grade assigned in
them? for example if a student fails to submit and assessment item I do not
want to assign a final grade. Can Excel 2003 stop the final grade cell being
completed based on a formula in the cell?

Thank you very much for your help with this.

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

I've tried several of the common tricks to try to convert what looks like numbers to numbers. (content from a main frame system). When I do the =ISTEXT( ) or ISNUMBER of course they reflect "text". I've converted before and don't recall it ever being this difficult. What am I missing here?
See attached file for sample.
I'm not understanding why the TRIM does not seem to work, nor do the common PASTE/SPECIAL or +1 tricks to convert the text to numbers.....?
What steps should I take to convert lists of data that look like this?

What started this? Well, I was trying to use this function =INDEX(SOURCE!A:A,MATCH(C2,SOURCE!B:B,0),1) to pull content from one sheet to another --- but could not get it to work and assume it's because it sees the content as 'text'. When I use this formula with numbers I keyed in by hand it works great. I also tried sorting in ascending -- but still no luck...

Hi,

I have a sheet of several thousand rows and about 25 columns. When I
export the data into excel there are many numbers that come through as
text with the little green triangle in the upper left hand corner. In
the past I would just manually change them by highlighting the cells in
questions and hitting the pop up box that let me convert the text to
numbers. When I record that step of manually converting the text in
the macro recorder nothing happens. Does anyone know how I can have
macros convert this data for me?

Thanks as always,

Eddie

--
punter

------------------------------------------------------------------------
punter's Profile: http://www.excelforum.com/member.php...fo&userid=2044
View this thread: http://www.excelforum.com/showthread...hreadid=551258

I tryed following the instructions for converting text to numbers and it
didn't work.
I am sure someone has had this problem. Any help appreciated.

thanks,

kris

For some reason the column headings have changed from letters to numbers.
Row headings still appear with numbers. This is happening in all my excel
workbooks so it must be some sort of global change that I have inadvertantly
made. Does anyone know why and what I need to do to change it back. (Excel
in Office 2000.)

Many thanks

The number in the cells are formatted as text, how can I convert them back to
number quickly. There are around 5000 cells in Excel Spreadsheet of Version
2000.
I tried: Format, Cell, Number, F2, but the conversion is number by number
and it takes too long.

We have a software package from which we can export data to MS Excel.
However, when exported it arrives in Excel as text. Even though they are
numbers, they act like text. The only way to convert them text to numbers is
to edit the cell (press F2) and hit enter. I've tried every other method of
copying and pasting (even pasting special), but nothing seems to work. Any
ideas?

How would i convert a date to number as a string

e.g. 10/05/2005 > "20050510"

note the month is 2 digit - 05

i cant see Format(A1,"yyyy,mm,dd") & i tried = year(a1) & month(a1) &
day(a1)

but it returns month as single "2005510"

Hi Team,

How can i convert text columns to numbers in VBA.

Could someone advise how to do this.

Regards,
Shekar.

Using Excel, i have a machine run time log ex 45,502hours 30minutes, how do i
convert all values to number format (45,502.5)?

I have 3 sheets. On each of the sheets there is a col labeled LOT#. Most of the time the values in the col for Lot# are numbers. However, some of the time the values are actually "text". Is there a way to test to see if the numbers are "text" and if so is there an efficient way to convert the col of values to numbers?

any help would be appreciated.

thanks.

Morning,

This is my first thread.

We use Excel 2007 to keep track of global assets by their serial numbers (which are often barcoded).
We have a new product with a new barcode that scans the following

Item S/N: 54079
When we scan the Barcode onto Excel in TEXT format, it reads as: 02690600070000054079

If I try to scan the barcode onto Excel in Number format (or try to convert from Text to Number), it reads as: 2690600070000050000
**Notice it omitted the actual serial number digits of "54079"

Is there any way I can I can apply a formula in Excel to remove the numbers of "026906000700000"??

I would like to have the data in Excel consistent with the serial numbers that are printed on the items.

PS: I can scan these items onto Notepad, then extract them onto Excel through the External Data feature.
However, since we track and scan thousands of these, it would be much simpler to have it all done in Excel, rather than go back & forth from Notepad to Excel.

Any help is appreciated, we keep track of over 6,000 of these items.

Adan V.

Hi,

I am currently trying to find an easy way to convert cell references to number format.

The issue I'm having is when compiling a small formula (CONCATENATE) as part of a macro in order to produce a unique reference number to a column of data (1000's of cells long) I come accross the age old number stored as text issue after the macro has converted the formula to values.

Have tried editing the macro to number stored as text = false which removes the annoying little red triangle but the vlookup functions still wont read the values. My current solution is to highlight the entirity of the data and convert to number which takes a long long time as there are multiple lookups assigned to the cells, which for my current project is not acceptable.

Am looking for a quick solution, (with no interaction required) something that would convert the cells to the format required either before the formula is assigned and overwritten by values or just after. Currently I'm stumped.

Any help most welcome and appreiciated!


No luck finding an answer? You could always try Google.