Hi,

I am having difficulty creating a formula to work out commission.

The scenario is as follows:

$0 - $400,000 commission is charged at 3.95%

$400,000 + commission is 2%

How can i create a formula which can workout what commission is earnt for any price?

For Example, on a $500,000 sale:
First $400,000 is $15,800
Further $200,000 is $4,000
Giving a total commission of 19,800.

Many Thanks!!