vendredi 8 mai 2015

Buyers Premium Excel Calculation

Dear StackOverflow Readers,

I have this deadline in the next few hours and I would really appreciate your help.

I need to create a formula to calculate buyer premium fees from the hammer price at an auction.

It works like this.

The hammer price is = X

Tax1 £0-£100,000 = 25% (Every sale is charged 25% up to the value of £100,000 so max is £125,000 for this part)

Tax2 £100,000-£2,000,000 = 20% If the hammer price exceeds £100,000, then 20% is added for this portion.

Tax3 £2,000,000+ = 12%. If the hammer price exceeds £2,000,000, then 12% is added to this portion.

Could anyone help me create a formula that would allow me to enter the hammer price and it would auto-calculate the total fees and give me the total price including those 3 taxes.

I'm willing to send the winning answer £5 by paypal if that helps, if you can get me a working answer in less than 2 hours that will work for any amount between £10,000 to £15M.

Thanks,

Darren Starr

Aucun commentaire:

Enregistrer un commentaire