|
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 |
Help assigning a number to a word
modicon2 Wrote: 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! Hi modicon2, I'm not quite sure if I understand you correctly, but try this in A1 - exm:10 in B1 - Red in C1 - 2 in D1 =LEFT(A1,4)&C1+RIGHT(A1,2)*1&" "&B1 Is this it? oldchippy :) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=573268 |
Help assigning a number to a word
Sorry about any confusion. I tring to make a work sheet that can use TEXT (I want to assign a number/constant to each unique TEXT) in math formulas. I want to define the word/text "Red" = 10, "Green" = 11 and etc. so that when I use a formula like = A1 + 2 (where Cell A1 has the word "Red" in it) the result would be 12. (Where Cell A1 has the word "Green" in it) the result would be 13. Thanks again -- modicon2 ------------------------------------------------------------------------ modicon2's Profile: http://www.excelforum.com/member.php...fo&userid=4158 View this thread: http://www.excelforum.com/showthread...hreadid=573268 |
Help assigning a number to a word
modicon2 Wrote: Sorry about any confusion. I tring to make a work sheet that can use TEXT (I want to assign a number/constant to each unique TEXT) in math formulas. I want to define the word/text "Red" = 10, "Green" = 11 and etc. so that when I use a formula like = A1 + 2 (where Cell A1 has the word "Red" in it) the result would be 12. (Where Cell A1 has the word "Green" in it) the result would be 13. Thanks again OK, Try this, I've assumed some colurs here, besides Red & Green, you can edit to suit. =IF(A1="Red",10,IF(A2="Green",11,IF(A3="Blue",12,I F(A4="Pink",13,IF(A5="Black",14,IF(A6="Purple",15, IF(A7="Orange",16,""))))))) This allows for seven different colours, the IF formula is limited to 7 only Is this any good to you? oldchippy :) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=573268 |
Help assigning a number to a word
Try this.
Insert Name Define Red Refers to =10 Add Green Refers to = 11 Add Blue Refers to =12 etc etc etc OK In the worksheet the formulas =(Red+Green)/Green returns 1.2 =Red+Green+Blue returns 42 =Red^2+(Green-Blue) returns 108 And so forth... HTH Regards, Howard "modicon2" wrote in message ... 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 |
Help assigning a number to a word
Hmmm...
After further review, my suggestion is not what you are looking for. Mine requires typing the color instead of referencing the cell with the color in it. Sorry... Regards, Howard "modicon2" wrote in message ... 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 |
Help assigning a number to a word
Thanks to everyone for their replies... VLOOKUP was the trick. It does actually what I want. Thanks again!!! -- modicon2 ------------------------------------------------------------------------ modicon2's Profile: http://www.excelforum.com/member.php...fo&userid=4158 View this thread: http://www.excelforum.com/showthread...hreadid=573268 |
| All times are GMT +1. The time now is 12:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com