Converting Text to Numbers then Calculating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I convert a letter in a cell to a number?

Example: Type the letter F in cell B3. Type the letter A in cell C3. The letter F represents the number 15, the letter A represents the number 30. (The letters F and A must remain visible in their respective cells.) Cell D3 will add the value of the two letters (15 + 30) and subtract this sum (45) from 100 showing a total of 55 in cell D3.

Can you help?
 
Are the values assigned to your letters arbitrary? If so, create a table of
letters with their values elsewhere in your workbook like so:

Sheet2:
A1: Letters
B1: Values
A2: F
B2: 15
A3: A
B3: 30

Then in the sheet you described:

D3:
=100-VLOOKUP(B3,Sheet2!$A$2:$B$3,2,0)-VLOOKUP(C3,Sheet2!$A$2:$B$3,2,0)

If the assignment is not arbitrary, what criteria do you use in assigning a
letter a value?

/i.


Ebony Monarch said:
How would I convert a letter in a cell to a number?

Example: Type the letter F in cell B3. Type the letter A in cell C3.
Click to expand...
The letter F represents the number 15, the letter A represents the number
30. (The letters F and A must remain visible in their respective cells.)
Cell D3 will add the value of the two letters (15 + 30) and subtract this
sum (45) from 100 showing a total of 55 in cell D3.
 
Back
Top