if statement - Buyers Premium Excel Calculation -

i have deadline in next few hours , appreciate help.

i need create formula calculate buyer premium fees hammer price @ auction.

it works this.

the hammer price = x

• tax1 £0-£100,000 = 25% (every sale charged 25% value of £100,000 max £125,000 part)

• tax2 £100,000-£2,000,000 = 20% if hammer price exceeds £100,000, 20% added portion.

• tax3 £2,000,000+ = 12%. if hammer price exceeds £2,000,000, 12% added portion.

could me create formula allow me enter hammer price , auto-calculate total fees , give me total price including 3 taxes.

the code have far this:

tax 1 = if(b3<=100000,b3*0.25,100000*1.25)  tax 2 = if(b3<1900000,b3*0.2,1900000*0.2)  tax 3 = (b3-2000000)*0.12  

you can use simple if statement same

please refer formula in address bar below.