Building a Pricing Model
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.
|