Generate a value from three different inputs

Welcome to the forum!

You are going to need to explain your pricing structure fully - what constitutes what price?

Hi Jake- we're gonna need to know how your prices work. You have two options:
1) Create a "Decision Tree", a set of rules we can incorporate in a formula to generate prices.
2) Create a "Lookup List" showing all possible combinations of inputs, with the associated price.

Option 1 is more flexible, but can potentially get REALLY complex. Option 2 is simpler, but requires more work if you change the number of inputs.
I've attached a workbook w 2 worksheets. One shows the 50 possible combinations of Material, Size, and Quantity. The other shows those plus the "Custom" choices (72 combinations). Use one of these to build a Lookup, or let us know what rules you want for a Tree. Thanks-Lee

Regarding pricing what logic calculating.

PHP Code: 

Size = 1G, Material = Plastic and Quantity = 1,000 the price would equal $500. 


In above case per unit cost $2.00

PHP Code: 

But if Size = 1G, Material = Plastic and Quantity = 2,500 then the price would be $1,000. 


In this case per unit cost $2.50
As per maths calculation price calculating $1250

I think (as per my view) prices applicable at the time of supply. In above two cases you not mentioning time period between two cases. At the time of second case prices, is the prices changed? If yes, then you maintained prices as per date period.

Originally Posted by leelnich

Hi Jake- we're gonna need to know how your prices work.

I believe this will work! Thank you so much, I'll check back in tomorrow to let you know my results. Thanks again!