Need to make a drop down list of 3 items that input a value in ano

  • Thread starter Thread starter solarflare
  • Start date Start date
S

solarflare

I have a savings calculator that i am working on. we have three products
that i would like the user to be able to select from. basis their selection
from the drop down list, i would like a corresponding value to go into a
certain cell.
how do i do this???
 
To create the dropdown list:
- select the cell where you want it to appear
- select Validation from the Data menu
- choose List
- you can either type in the list of items, separated by commas, or use the
grid button next to the textbox to select a range of cells that has the list
of products
- click OK

To populate the other cell (say, E5) based on the dropdown cell:
- enter a formula similar to the following in E5
=IF(D5="AA",100,IF(D5="BB",200,IF(D5="CC",300,0)))

In this example, the products are AA, BB, and CC. The dropdown list is in
cell D5. The corresponding amounts are 100 for AA, 200 for BB, and 300 for CC.

Hope this helps,

Hutch
 
Back
Top