challange
 

Hello Here is a Challange:
I have a drop down list in a cell 252 entries, when you make a choice
the choice will be like this (read like this) 1/5. Ok, so now I want
the cell next to the drop down list to covert or reference a value in
the form of a multiper. decimal point. So in this case when you choose
1/5 from the drop down list the cell next to this will read .95. That
is because 1/5 equals that. So the second example will be next choice
in the drop down list 1/5 & 1 the cell next to this will now be the
decimal of this, that is .9405. How can I make this happen.

Thanks let me know...


--
Michael D Bay
------------------------------------------------------------------------
Michael D Bay's Profile: http://www.excelforum.com/member.php...o&userid=31842
View this thread: http://www.excelforum.com/showthread...hreadid=515636

challange
 

i dont qite follow..1/5 was 0.2 when i went to school.would it be as easy as
a vlookup tble where the left hand column is your drop down list and your
values you want returned are listed in the second column,so your cell next to
the drop down is =vlookup(value from dropdown list,dropdown list 2 column
table,2,false)
--
paul
remove nospam for email addy!



"Michael D Bay" wrote:


Hello Here is a Challange:
I have a drop down list in a cell 252 entries, when you make a choice
the choice will be like this (read like this) 1/5. Ok, so now I want
the cell next to the drop down list to covert or reference a value in
the form of a multiper. decimal point. So in this case when you choose
1/5 from the drop down list the cell next to this will read .95. That
is because 1/5 equals that. So the second example will be next choice
in the drop down list 1/5 & 1 the cell next to this will now be the
decimal of this, that is .9405. How can I make this happen.

Thanks let me know...


--
Michael D Bay
------------------------------------------------------------------------
Michael D Bay's Profile: http://www.excelforum.com/member.php...o&userid=31842
View this thread: http://www.excelforum.com/showthread...hreadid=515636