Sheets Formula
Budget: $10 – $30 USD
Need formula to calculate commission amount for a given period when there is a change in the commission tiers (different percentage based on amount sold). example:
Commission Tiers: 0 to 400k is 5%, 400.01k to 600k is 6%, etc..
Q2 Person A sold 500,000.
When using a Lookup function how do you write a formula to calculate the difference and what is owed at the different percents as they jumped from one tier to the next in the same quarter.
Commission Tiers: 0 to 400k is 5%, 400.01k to 600k is 6%, etc..
Q2 Person A sold 500,000.
When using a Lookup function how do you write a formula to calculate the difference and what is owed at the different percents as they jumped from one tier to the next in the same quarter.