Hi Community! I need some assistance please. I am trying to create an Excel file that will help me calculate my commissions, but there's an error in the formula I created.
Here's our structure:
<tbody>
</tbody>
The formula I created (that is not calculating correctly) is:
=(MIN(C2,10)*3.5)+(MAX(MIN(30,C2-10),0)*2)+(MAX(MIN(100,C2-30),0)*1)+(MAX(C2-100,0)*0.5)
Will you please advise what the correct formula is for this commission structure to calculate properly?
Thanks in advance!
Here's our structure:
# of Members | Commission Per Member |
0-10 | $3.50 |
11-30 | $2.00 |
31-100 | $1.00 |
>100 | .50 |
<tbody>
</tbody>
The formula I created (that is not calculating correctly) is:
=(MIN(C2,10)*3.5)+(MAX(MIN(30,C2-10),0)*2)+(MAX(MIN(100,C2-30),0)*1)+(MAX(C2-100,0)*0.5)
Will you please advise what the correct formula is for this commission structure to calculate properly?
Thanks in advance!