Can I assign a numeric value to words in Excel?

G

Guest

What I need to do is assign a numeric vale to various words and calculate the
total. (e.g.) Warm=1 point, Hot =2 points, Scalding =3 points
Cool =1 point, Cold =2 points, Freezing =3 points
So if I have "Hot" and "Freezing" in one row is it possible to get the score
total of 5?
Thanks for any help I can get,
Josh
 
A

Alan

Use a look-up table and the VLOOKUP function but don't forget to use
the False option if you enter your data into the table in numerical
rather than alphabetical order.
 

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

moving answer from one sheet to another 1
How do I do this??! 1
Who can help the NYPD with an Excel formula? 20
Assign text to numeric value 5
I need to exclude a value from a list based on a corresponding value. 2
Scrabble Value calculation for Welsh words 0
Formula. Way over my head 7
Another "World Cup" related query 4

Top