I'm sure it must be easy
Hi Brian
If your values are always going to follow that pattern, then with your
dropdown selection in A1, enter in B1
=A1/100*15
--
Regards
Roger Govier
"BrianH" wrote in message
...
I have a real simple worksheet that has a list box of 10 items. When I
choose
one of the items from the list I want it to auto fill the next cell with a
amount.
If I pick $100 from the dropdown list, I want it to populate the next cell
with 15.
$100 - 15
$200 - 30
$300 - 45
|