| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help assigning a number to a word
Greetings, I would like to assign a number (exm:10) to the word "Red". so that.. Cell:A1 has the word "Red" Cell:B1 has a number..lets use 2 Cell:C1 has the formula "=A1+B1 I want the result to = 12 [exm:(Red which is 10 + 2)=12] My wookbook will end up with about 50 different words assinged to 50 different numbers. anyhelp would be greatly appreciated. Thanks! -- modicon2 ------------------------------------------------------------------------ modicon2's Profile: http://www.excelforum.com/member.php...fo&userid=4158 View this thread: http://www.excelforum.com/showthread...hreadid=573268 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking a Specific Word to a Specific Number | Excel Worksheet Functions | |||
| Searching for mulitple strings and assigning identifying number | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| The last column in my word document contains both text and number | Excel Worksheet Functions | |||
| Assigning a number value to a letter? | Excel Discussion (Misc queries) | |||
Threaded Mode
