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

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

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

ah the wonderfull V lookupwins again!
you need to make a table somewhere with your colours listed in one column
just say D1 down to D50.In E1 to E50 you have your assigned numbers
in a3 you have your formula of =Vlookup(a1,D1:e50,2,false)+a2
The only variation is your addition number is also in a cell,in this case A2
--
paul

remove nospam for email addy!



"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


--
modicon2
------------------------------------------------------------------------
modicon2's Profile: http://www.excelforum.com/member.php...fo&userid=4158
View this thread: http://www.excelforum.com/showthread...hreadid=573268

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

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

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

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