How do I (or can I) create "IF" conditions in the calculation field.
Trying to figure out how to configure a sub-total based on Quantity, # of Sets and Type of Paper.
I have multiple 'paper styles', each with their own price per units. (ppu)
I have multiple 'quantity' options as well.
Price Dependancies:
Paper price per unit --> Dependant on --> Quantity (price per unit of paper decreases as the quantity increases)
* NOTE: Paper price is not dependant on "# of Sets", just "Quantity"
My formula would be something like this:
(Quantity * Sets) * Paper = SUB TOTAL
Ex. Customer requires 1000 items, on plain paper and 2 sets of them.
So if plain paper has a price per unit of $0.50 at 1000 items the cost would be $500.00.
If they request 5000 items, the price per unit would be $0.25. Total being $1,250.00.
Can anyone show me an example of a calculation that has tiered options, or uses "IF" conditions...or something like that.
