Building a Pricing Model

  • Thread starter Thread starter HomeAppreciators
  • Start date Start date
H

HomeAppreciators

I want to assign a dollar value to the text cells in the drop down menu
I inserted into my spreadsheet. Each drop down selection will have a
corresponding $ amount so the final price formula can be automatically
calculated.

Hardwood floors = $5.00
Carpet = $2.00

I've tried to find the info on-line but I'm a little lost. Sorry if
this is a simple question.


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+
 
HomeAppreciators;950723 said:
I want to assign a dollar value to the text cells in the drop down menu
I inserted into my spreadsheet. Each drop down selection will have a
corresponding $ amount so the final price formula can be automatically
calculated.

Hardwood floors = $5.00
Carpet = $2.00

I've tried to find the info on-line but I'm a little lost. Sorry if
this is a simple question.
Click to expand...


Hi by using a simple drop down box, you can do this.
step 1: right click on drop down box, choose format control
step 2: click on CONTROL
step 3: Define Input range
step 4: Cell link (this is flag indicator)

Please refer to sample spreadsheet that attached with your example

Thanks
bALA


+-------------------------------------------------------------------+
|Filename: Example.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=136|
+-------------------------------------------------------------------+
 
Back
Top