Hello,

So I am in manufacturing, and we do stainless steel fabrication.

The pricing is usually given manually, my boss would quote the customer and so on but recently, i've been given responsibility to quote as well and I rather have an excel sheet to quickly quote based on dimensions (length, depth and height).

I made a very rudimentary price sheet but it would go out of wack as soon as I go above 1000 mm in length or depth (all my dimensions are in millimetre), so I created a "co-efficient" to control it but now, if I go too low, below 300mm, my pricing would be crazy high.

I tried =IF(B6>1000,1,0.9), so my "control" price will multiply based on 1 or 0.9 based on the size but obviously this doesn't work once i go above 2000mm and it covers too much to fine tune.

So what I am doing is trying to create a formula, like y=mx+c, as the dimensions go higher, the price increase becomes smaller. But I have no idea how to do this, any suggestions?