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!

For example, a student gets a D on one assignment and a B on another. I want a formula that will produce "C".

Thanks!

- Converting Letter Grade to Numerical Value
- Converting Letter Grades to Numeric
- Formula request: converting letter grades to numbers so they can be averaged.
- Convert Number To Letter
- Macro To Change Letter Grade To Number Grade
- Convert character count to number w/ in cell
- Converting military times to numbers
- Try to convert letter grades into GPA grade points
- Try to convert letter grades into GPA grade points
- Converting a letter grade to a numerical value
- Converting a letter grade to a numerical value
- Assign Consistent Letter Value to Grade percentage
- Convert Text To Number Won't Work
- Having macro convert text to numbers
- Converting copied data to numbers in excel xp
- Why have column letters changed to numbers in excel
- Convert text-format number to number in excel 2000%3f
- How to convert Excel imported numbers from text to numbers?
- Convert Date to number?
- Converting text to numbers in vba
- How do I convert run time(45,502h 30m) to number 45,502.5 ??
- Converting text col to numbers if necessary
- Converting "Text" to Numbers, For Serial Number Tracking
- Converting Text to number issue

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

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

For example, a student gets a D on one assignment and a B on another. I want a formula that will produce "C".

Thanks!

Thanks,

---MC

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.

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.

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.

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

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.

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.

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.

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

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

didn't work.

I am sure someone has had this problem. Any help appreciated.

thanks,

kris

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

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.

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?

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"

How can i convert text columns to numbers in VBA.

Could someone advise how to do this.

Regards,

Shekar.

convert all values to number format (45,502.5)?

any help would be appreciated.

thanks.

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.

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!