# IF/THEN

• ### Question

•

I have been searching for days..what formula is used when you can give a letter a value. I am trying to keep a steady tab on my GPA and i want to be able to put in my actual grade instead of the point value but i know there is a formula that can give that grade a value. Someone please help thank you so much
Tuesday, August 5, 2008 7:19 PM

• Assigning values to letters (or symbols) can be done in hexadecimal, binary, ASCII format. Explaining formulas would take some pages. Just type in calc at run and you can calculate values. If you're looking to assign values to letters in the sense of grades, I suppose you can make your own schema in excel.

Shems

This is a break

AvOiD CaPs In HtMl-CoDe; xHtMl Is NeAr.

Information by Experience

Thursday, September 4, 2008 8:09 AM

### All replies

• Assigning values to letters (or symbols) can be done in hexadecimal, binary, ASCII format. Explaining formulas would take some pages. Just type in calc at run and you can calculate values. If you're looking to assign values to letters in the sense of grades, I suppose you can make your own schema in excel.

Shems

This is a break

AvOiD CaPs In HtMl-CoDe; xHtMl Is NeAr.

Information by Experience

Thursday, September 4, 2008 8:09 AM
• In excel you can create a table with the grade points in one column (in assending order) and the letter grade in another column.

use a formula like this:

where "A2" is the cell referance with the numerical grade points and "Grade" is an array table.

This will convert numbers to letters. If what you want is the other way around, you can't use LOOKUP because you need numeric values, but you can use:

=VLOOKUP(D2,Num,2,0)

where "D2" is a letter grade cell referance, such as "C+" or "B-", "Num" is an array, "2" says the answer is in the 2nd column and "0" is exact match. As before, the array table must be in assending order. There needs to be a value assigned to every possible letter grade.

Friday, September 19, 2008 9:42 PM
• >BUMP<

this post is waiting to be answered or to be marked as ..

Shems

Sunday, November 23, 2008 1:26 PM