Re: Calculating the total commission value from a sliding scale
thank you KjBox, the one you attached work perfectly. I pasted then retyped the formula as i thought maybe something woring with the pasting but also gave error. But yours work perfectly. Thank you again.
Re: Calculating the total commission value from a sliding scale
I have placed the sales value in A1 (to test the formula before i change anything) - The formula totally makes sense but excel give me error that they found a problem with the formula
Re: Calculating the total commission value from a sliding scale
Thank youKjBox, yes you correct, must be 9900, blue monday 
The formula giving error, but understand your logic in the formula, going to play around a bit - did try to add sum in but still giving error. Will let you know once it works. Thank you so far!
I am trying to figure out how to work out the total commission payble to an agent when you enter a purchase price. The commission is calculated on a sliding scale as follow for example:
For the first 100 000, the commission the agent gets is 5% of the purchase price, for the next 100 000, thus from 100 001 - 200 000, he gets an additional 4.5%, then for 200 001 - 300 000, he gets and additional 4%, for 300 001 - 400 000, its 3.5% then anything over 401 000 he gets 3%.
Thus say Purchase price is 210 000 - he gets 5 000 for 1st 100 000, 4500 for next 100 000 and R400 for the balance, so total commission on R210 000 is 9800.
Now just to put it in a formula that we only need to enter the purchase price and the formula works out the commission per sliding scale.
