Trying to get a grid to spit out cost based on dimensions to work between

cubeyy91

New Member
Joined
Jan 31, 2018
Messages
2
Hi all,
I work at a glazier and I am trying to create a grid for the office girls to work from to be able to quote people over the phone easily.
We cut glass from standard sheet sizes that we stock so there is a size range to work from and here is an example:

600 x 1000$290
600 x 1500$310

<colgroup><col width="206"><col width="65"></colgroup> <tbody>
[TD="width: 206"] 600 x 600 [/TD]
[TD="width: 65"] $270 [/TD]

</tbody>

So, if a customer asks for a bit of glass that would be 500x1200 we know we charge $310. I want them to be able to put sizes in and it just spit the price so there is no confusion.

To make it even better I would love to be able to have a drop down that allows you to choose the glass type which would vary the pricing. This is because 500x1200 in one type could be $310 but if it is lower to the ground it may require stronger glass and it might be $400.

I would be willing to have one setup just for the sizes and just create a different colour box to put dimensions into for the price to be spat out but all in one size section would be great.

I have been searching for hours but to no avail.

Thoughts?
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Hi and welcome to the Forum.

It would be best if you post a table of standard sizes and types of glass in the kind of format you would like. That way fewer changes to the first answers will need to be made.

Cheers

Paul Ked
 
Upvote 0
Hey Paul,

Thanks for taking the time to reply. Here is what I am working with
5mm Clear Glass
600 x 600270
600 x 1000290
600 x 1500310


Standard Sliding and Fixed Glass Windows
1400 x 600290
1400 x 1200330
1400 x 1500390


Bathroom Windows
Obscure Safety Glass
600 x 600290
1400 x 600370
1400 x 1200490


Toilet Windows
Obscure Glass
600 x 600290
600 x 1000370


Door and fixed panel (Clear Glass)
2100 x 900530
2100 x 1200650
2300 x 900770
2300 x 1200880

<colgroup><col width="206"><col width="65"></colgroup> <tbody>
[TD="width: 206"] Ground Level Windows (Lowlite) [/TD]
[TD="width: 65"]
[/TD]

</tbody>
 
Upvote 0

Forum statistics

Threads
1,223,236
Messages
6,170,915
Members
452,366
Latest member
TePunaBloke

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
Back
Top