Hi Board,
I'm trying to create a formula to calculate a tiered commission schedule. The schedule is:
50% for up to $10,000
60% for $10,001-$15,000
70% above $15,000
So far I have figured out a formula that calculates all the commissions but I can't get it to stop taking the 50% after 10,000 or the 60% after 15,000. Please help!
thanks!
Sarah
I'm trying to create a formula to calculate a tiered commission schedule. The schedule is:
50% for up to $10,000
60% for $10,001-$15,000
70% above $15,000
So far I have figured out a formula that calculates all the commissions but I can't get it to stop taking the 50% after 10,000 or the 60% after 15,000. Please help!

thanks!
Sarah