Is there a formula for excel that allows me to ascribe a numerical value for a letter?

Question

Its for numerology so A = 1 B = 2 etc then I would like for the programe to calculate the totals

So for the word FAR it would show 6118 and be able to calculate the horizontal value of 16 (6+1+1+8) and the vertical value of 25 (6+1+18). Its an unusual type of numerology

Thanks so much in advance
If I could so it it would save me sooooo much time

Answer 1

hmmm...an if statement would get real long.

f=6

a=1

r=18 and you want 1+8 horizontal...that would be 9



the vertical would be straightforward.



heres (see source) a scrabble question that came up, and was answered by Sarah. iit has scrabble letter values. all you would have to do is use the formula and adjust the 26 numbers to be the numbers you want.



it should be pretty easy...since theres already 1 letter for each number.

let me know with a question update if you have trouble getting it working, its usually a just missing comma. cut&paste what youve tried, and i can go through the numbers and make it an easy cut&paste. i will let you try it 1st :o)

good luck



remember to hit Ctrl-Shift-Enter and not just the Enter key.

Answer 2

1

Answer 3

Excel could do that but the formula would be pretty complicated. To keep it more simple you would need to type each letter into a different cell. - otherwise the formula will also have to include extracting the first letter, the second letter, etc from each cell.



The previous poster is correct that the best formula for this would be the "IF" command - but you have quite a learning curve ahead of you if you want to produce it your self.

Answer 4

Create a VLOOKUP table with the letters down the left column of the table and the corresponding number that you want to assign in the column to the right of the letters. If the table is in M1:N26 this formula will work assuming that you are putting the letter in A1 =VLOOKUP(A1,M1:N26,2,0) This will look at the value in A1, find it in column M and return the value from column N.

Answer 5

I believe this will work - I used a custom function rather than Sarah's slicker way of using arrays. It's a little long hand, but so long as you're not doing this for 20 thousand cells at once, it should be manageable. Open up the Visual Basic Editor (Alt F11), insert Module, and paste the following code. Then just reference this function as if it were any other function. (e.g., =numerology("far") = 6118)





Function numerology(word)

letters = Array("a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n", _

"o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z")

For ltr = 1 To Len(word)

For indx = 1 To 26

If LCase(Mid(word, ltr, 1)) = letters(indx - 1) Then

numerology = numerology & indx

Exit For

End If

Next indx

Next ltr

numerology = Val(numerology)

End Function

Answer 6

If you want to understand your dwell deeply than you can mix the study of numerology and astrology like you will uncover right here https://tr.im/a7VuC , the best feasible guidebook so that you figuring out how to navigate through your lifestyle the ideal way.

According to the internet site Numerologist, in purchase to make the ideal feasible choices in your daily life, you’ll need to have self comprehending and self acceptance, each of which will be easier for you to grasp if you have access to the patterns which are creating up your existence path and to do that you will need to have the studying that this internet site can proportionate you.

Answer 7

Try an IF/THEN formula