can a conditional formulas be setup using text to get a numerical
 

I want to set up a condtional formula that if I would enter a word like star
I would get a numercial result in the cell next to it like number 55, If I
type the word finsih in the same cell I would get a result 95

can this be done?

can a conditional formulas be setup using text to get a numerical
 

Only 2 values, just use

=IF(A2="star",55,if(A2="finish",95,""))

if more values use a vlookup formula


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"abe" wrote in message
...
I want to set up a condtional formula that if I would enter a word like
star
I would get a numercial result in the cell next to it like number 55, If
I
type the word finsih in the same cell I would get a result 95

can this be done?