GaryB
07-25-2011, 05:21 PM
Hi,
I am trying to create a pricing grid that a customer can enter a quantity and see what the pricing will be. The per each price would be hid. I created the worksheet attached and the problem I have is if, lets say, I put a 199 quantity in the 100+ range the cost is extremely higher that 200 in the 200+ range. Obviously one of the problems per each price remains constant in each range and go lower as the quantity increases. From what I can figure out is I need to incorporate a sliding scale to have this accurately price and I am at a compete loss on how to do this. I have attached an Excel sheet so you can see what I have done and hopefully someone can steer me in the right direction. Any help will be appreciated.
Thanks
Gary
I am trying to create a pricing grid that a customer can enter a quantity and see what the pricing will be. The per each price would be hid. I created the worksheet attached and the problem I have is if, lets say, I put a 199 quantity in the 100+ range the cost is extremely higher that 200 in the 200+ range. Obviously one of the problems per each price remains constant in each range and go lower as the quantity increases. From what I can figure out is I need to incorporate a sliding scale to have this accurately price and I am at a compete loss on how to do this. I have attached an Excel sheet so you can see what I have done and hopefully someone can steer me in the right direction. Any help will be appreciated.
Thanks
Gary