I need some help. I want to make a simple substitution formula. I need to
assign a numerical value for each letter of the alphabet starting with the
number 6. For example A = 6, B = 12, C = 18 and so on. I then could type a
single letter into a cell and then in an adjacent cell display the number.
The letters would be in one column, the numbers in the next. At the end of
the displayed numbers, I would then total the numbers to receive value for
the letters. I have tried IF statements, but those are too long, and MATCH,
but I could not get it to work. Any ideas are appreciated.
Thanks,