If function and capability

I'm working in Excel right now trying to create a spreadsheet for window pricing.    Quick example, if I'm building a quote for a window install and the option from the drop down menu is single ope...