Tier Price

Tier Price. Calculate with Order quantity, Discount threshold quantity, Base unit price; review the formula, units and worked example.

Processed locally · Files stay on your device

Values and units

Runs in this browser

Set the inputs and run the tool to view the result.

Review the populated example and the input units, then replace it with your data.
Calculate with Order quantity, Discount threshold quantity, Base unit price; review the formula, units and worked example.
Run the tool, inspect the result, then copy or download what you need.

quantity*price*(1-ifgte(quantity,threshold,discount,0)/100)

quantity*price*(1-ifgte(quantity,threshold,discount,0)/100)

Numbers retain the tool's existing precision. Keep monetary inputs in the same currency and enter percentages as percentage values.

Estimates depend on the inputs and the stated formula. Confirm contractual costs, carrier rules and applicable taxes separately.

Order quantity: 1200
Discount threshold quantity: 1000
Base unit price: 10
Discount above threshold (%): 5

Expected result: 11,400 currency

How does Tier Price determine the result?

quantity*price*(1-ifgte(quantity,threshold,discount,0)/100)

quantity*price*(1-ifgte(quantity,threshold,discount,0)/100)

Numbers retain the tool's existing precision. Keep monetary inputs in the same currency and enter percentages as percentage values.

What should I check before processing?

Estimates depend on the inputs and the stated formula. Confirm contractual costs, carrier rules and applicable taxes separately.

How can I verify the output?

Use the supplied example as a check, then compare important results with the original source or business document.

Order quantity: 1200
Discount threshold quantity: 1000
Base unit price: 10
Discount above threshold (%): 5

Expected result: 11,400 currency