challange

  • Thread starter Thread starter Michael D Bay
  • Start date Start date
M

Michael D Bay

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...
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down Lists 2
Filter a Drop List ? 1
How to Display 12.5 but not 25.0 (drop .0’s) 5
Filtered drop down list 2
Custom Format - Show 12.5 but not 12.0 (drop .0s) ? 2
Need simple step by step help 1
Select drop down menu option using libre-calc macro 0
Linking choices in drop down menu to have automatic answer... 3

Back
Top