IntermediateSalesAbout 6 minutes
Sample data
| Row | A | B |
|---|---|---|
| 1 | Sales from | Rate |
| 2 | 0 | 0.02 |
| 3 | 5000 | 0.04 |
| 4 | 10000 | 0.06 |
| 5 | 20000 | 0.08 |
Steps
Each formula is already filled in and calculated. Edit it and press Run to try your own version. Nothing is saved or uploaded.
The table lists the lowest sales for each rate. Look up the rate for 12,500 with TRUE (approximate match).
Result
Try a value just below a threshold.
Result
Multiply the sales by the rate to get the commission.
Result
A less round example, rounded to two decimals: sales of 8,333.
Result
Show the rate as a percentage text.
Result
What to remember
Approximate matching (TRUE) only works if the first column is sorted from smallest to largest.
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.