I have a row in excel that calculates commissions. Once the total gets to $8,000 (B6 in the below example), I want the formula to no longer calculate commission. Commission should be zero.
What formula do I put into the B column? Whenever I do an IF formula, I get a circular reference because I am referring to B6 in the formula (which is summing all of B column)
<tbody>
</tbody>
What formula do I put into the B column? Whenever I do an IF formula, I get a circular reference because I am referring to B6 in the formula (which is summing all of B column)
A | B | ||
1 | 20% | ||
2 | Commision | Cap | |
3 | 5,000 | =A3*B1 | |
4 | 3,000 | =A4*B1 | |
5 | |||
6 | =SUM(B2:B5) |
<tbody>
</tbody>