Ok, I didn't quite understand that last part in your original post. Try this:

=IF(B6<7000,B6*0.45,IF(B6<9000,B6*0.5,IF(B6<13000, B6*0.55,IF(B6<16000,B6*0.6,9600+(B6-16000)))))

"cbrock" wrote:

Great thanks so much. One last thing, if B6 is 16000 it should multiply
16000 *.60 then add any amount over <16000.

Example:
IF B6 = 17500
Then the formula should do this (16000 *.60 + 17500-16000 = 11,100.00

In other words any commission generated 16000 the agent will keep plus
recieve 60% on the amount between 13000 & 16000

Corey
"Elkar" wrote:

This ought to do the trick:

=IF(B6<7000,B6*0.45,IF(B6<9000,B6*0.5,IF(B6<13000, B6*0.55,IF(B6<16000,B6*0.6,B6))))

"cbrock" wrote:

I am trying to create a formula that will calculate commissions depending on
bechmarks.
Example:
IF <7000 then multiply by 45%
IF 7000, but <9000 then multiply by 50%
IF 9000, but <13000 then multiply by 55%

The final part of the formula should be as follows:
If 13000, but <16000 then multiply by 60%, IF 16000, 100% of the amount
16000 is multiplyed by 100%