convert text to a value to be used in a formula

G

Guest

I need to identify specific text (letters) with a number and then be allowed
to use that number to calculate a formula. ie - "D" in a cell would be equal
to 10, "E" would be equal to 14, "D/E" would be equal to 24, etc.. I then
wish to add a string of cells that have been converted as above, to equate a
value. ie - 2 "D"s + 1 "E" = 1 "D/E" would calculatte to equal - 68
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Excel Need Countifs Formula Help 0
Relating text to a value 5
With F1 value, look at A, if match or partial match return B 5
Formula to find last different value in a column? 5
Using a formula to select a cell using the row and column values 7
How do I set up a formula to give me an average based on IF? 1
variable formula 4

Top