I am trying to create a formula to calculate sales commissions. I have four ranges based on the amount of a discount that was given and then the level of commission earned.
My table looks like this:
18-20% discount then a 3% commission is earned
16-17% discount then a 3.2% commission is earned
14-15% discount then a 3.4% commission is earned
12-13% discount then a 3.6% commission is earned
11-0% discount then a 4% commission is earned
In the main table I list each sale and the discount given. I'd like to automatically grab the sales amount, factor the appropriate commission level and calculate the commission earned.
Here's an example, I have a $1,000 sale with a 15% discount, sale amount is $850 with a 3.4% commission earned. The formula would then return a commission of $28.90
Bookmarks