asked on

commision

Hi, I am trying to create a formula based on a tiered commission.

the commission is anything up to 10, 000 you get 12% and once you hit 10,000 anything over that is 25%.

The formula works on anything up to 10,000 but once try to type past I just get #name

=IF(B17<=G5,(B17*0.12),IF(AND,$B$17>G6,(B17*0.25)))

Please not G5 = 10,000 on my spreadsheet, G6 = 10,001 Also B17 is the where the main number is

thanks for any help you can offer.

Kind Regards,

SOLUTION

Shums Faruk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tom Hurdiss

ASKER

Hi thanks for your help, I have tried that and it now picks up the figure. The only problem I am having is that it is not doing the separate percentages.

what I mean is that the I needs anything up to 10,000 to be 12 then any extra at 25% any idea how I can get this to work in this way?

thanks,

Shums Faruk

Can you post your dummy/sample workbook?

tom Hurdiss

ASKER

Yeah sure, please see it attached.
Copy-of-Perm-commission-calculator.xlsx

ASKER CERTIFIED SOLUTION

Shums Faruk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tom Hurdiss