Dear Mr. Excel,
I'm new to this forum.
I have been trying to assign a number value to each of 3 letter characters but have not found the correct function. Can you help?
Ultimately, one of these 3 letters will be typed into each cell within 1 column and the 3 corresponding numbers will be used in a formula to calculate the product of a second cell multiplied by this number to appear in a 3rd cell.
Any help will be appreciated. I have tried using 'VALUE' but I keep getting an error. Thank you.
offsup
I'm new to this forum.
I have been trying to assign a number value to each of 3 letter characters but have not found the correct function. Can you help?
Ultimately, one of these 3 letters will be typed into each cell within 1 column and the 3 corresponding numbers will be used in a formula to calculate the product of a second cell multiplied by this number to appear in a 3rd cell.
Any help will be appreciated. I have tried using 'VALUE' but I keep getting an error. Thank you.
offsup