Hello.
I believe I need a SUMIF.
This spreadsheet tracks current MTD sales and Trending MTD sales. There are percentages for commision tiers aswell. Base ($5400-$5999 is 25% of those sales), Tier 1 (>$6000-6999 is 30%), Tier 2 (>$7000-$10,000 is 32%) and Tier 3 (>$10,000 is 35%).
I want to create a formula that displays the results if greater or less than, then multiplies the percentage based off the tier it is in.
any suggestions.
I believe I need a SUMIF.
This spreadsheet tracks current MTD sales and Trending MTD sales. There are percentages for commision tiers aswell. Base ($5400-$5999 is 25% of those sales), Tier 1 (>$6000-6999 is 30%), Tier 2 (>$7000-$10,000 is 32%) and Tier 3 (>$10,000 is 35%).
I want to create a formula that displays the results if greater or less than, then multiplies the percentage based off the tier it is in.
any suggestions.