dropdown value

[Mark Scott]

Hi,

I am trying to create a worksheet formula which when a user select a value
from a dropdown box, the resut in the adjacent cell is affected differently
depending on that value. For example if any value between 1 and 5 is
selected, the result is .1, if any value between 6 and 10 is selected, the
result is .2, and if any value between 11 and 15 is selected in the
dropdown, the result is .3


Thanks,

 

[Frank Kabel]

Hi
in your example try
=IF(A1="","",(INT((A1-1)/5)+1)/10)

 

[Max]

Assuming the selection is made in cell A1,

Try in B1:

=IF(AND(A1>=1,A1<6),0.1,IF(AND(A1>=6,A1<10),0.2,IF(AND(A1>=10,A1<15),0.3,"Ou
t-of-range")))