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