Hi all,

Im new to the site and straight away would like a little help.

I need to create a basic template for my small business, which sells mobile phones.
I have created a draft (well I was donated it) which I put in my buying cost, selling cost, paypal etc and thats all fine, it works out the total profit at the end. but im struggling to find a formula for the following:

For mobile phones ebay Final Value fees column, it is 5.25% of the initial £29.99 (£1.57) plus 3.00% of the next initial £30.00 - £99.99 (£2.10) plus 2.50% of the remaining balance of the final selling price.

So if I sell a phone for 99.99, its 5.25% of the first 29.99, then 3% of the next £70.

All Ive done is =F3*0.0525 where F3 is the final selling price but how do I add in the above criteria?????

But then I am a powerseller and I get 20% off the total of this final value fee. Would it be easier to do the above calculation, then add in a new column that then takes 20% off of the calculated fees?

Any help on this would be great (I dont even know if it can be done!)