Proposal spreadsheet that will calculate cost based on input

windowman

New Member
Joined
Mar 3, 2005
Messages
1
I want to create spreadsheet I can use to calculate the price of my product, windows. A proposal I can give to my customer.

Price is determined by 4 variables, 1. style of window, 2. Installation type, 3. color, and 4. size. There are 8 styles of windows, 2 install types, 3 color and 10 different size catagories. Each window style has 60 different possible prices based on above info.

In simple terms, instead of manually looking up the price based on these items I want to be able to enter

Double Hung insert installation single color 85 inches

into a spreadsheet

and based on those 4 cell entries I want a formula in my price column to pull the correct price from another spreadsheet and have it automatically entered into the price cell.

Thank you
Mike :rolleyes:
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

P Sitaram

Well-known Member
Joined
Jun 24, 2003
Messages
1,974
Please give the layout of the other spreadsheet that holds the price data.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,384
Messages
5,601,326
Members
414,443
Latest member
lionking15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top