How it works
The first rate applies up to the threshold and the second rate only to sales above it. This form solves for upper-tier rate; enter the known quantities in Total commission (same currency), Sales subject to commission (same currency), First-tier sales threshold (same currency), First-tier rate.
Inputs and units
| Input | Example value | What to enter |
|---|---|---|
| Total commission (same currency) | 800 | Formula symbol: commission. Enter a numeric value. Use a non-negative value. |
| Sales subject to commission (same currency) | 20,000 | Formula symbol: sales. Enter a numeric value. Must be greater than zero. |
| First-tier sales threshold (same currency) | 10,000 | Formula symbol: threshold. Enter a numeric value. Must be greater than zero. |
| First-tier rate | 3 % | Formula symbol: first. Enter the percentage as a number: for 15%, enter 15. Use a non-negative value. Allowed range: 0–100. |
Worked example
Show example inputs and results
This example is generated by the same calculation engine using the starting values in the form. Your own inputs produce your own result.
- Total commission (same currency)
- 800
- Sales subject to commission (same currency)
- 20,000
- First-tier sales threshold (same currency)
- 10,000
- First-tier rate
- 3 %
Complete example results
- Upper-tier rate
- 5 %
Reading the result
The result solves for upper-tier rate from the entered quantities. Check the result unit and the formula conditions before using it.
Questions and answers
Can I use the example values for my own calculation?
The example values illustrate the calculation. Replace every input with your own information, especially dates, rates and the selected operation.
When can I use the upper-tier rate result?
There are only two marginal tiers; the higher rate is not applied to all sales. Solving the upper rate requires sales above the threshold. All monetary inputs must use the same currency; currency conversion, tax and automatic fees are excluded.
Why are some results rounded?
Results display up to 8 decimal places. Calculations use the unrounded values; very small values use scientific notation. JavaScript floating-point arithmetic can introduce tiny rounding differences.
Are my inputs sent to a server?
The calculator processes inputs in your browser. Its code does not send your values to a server.
Method sources: docs.oracle.com