Excel 2007 : Ebay Excel spreadsheet

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!)

Or this?

=IF(G16<=29.99,(G16*5.25%),IF(G16<=99.99,((1.57+(( G16-29.99)*3%))),IF(G16<=199.99,((1.57+2.1+((G16-99.99)*2.5%))),IF(G16<=299.99,((1.57+2.1+2.5+((G16-199.99)*2%))),IF(G16<=599.99,(1.57+2.1+2.5+2+((G16-299.99)*1.5%)),IF(G16>=600,(1.57+2.1+2.5+2+4.5+((G 16-599.99)*1%))))))))*0.8

brilliant thanks for your help dave, got the above off another forum works a treat!