I am trying to make a formula to work with the Technology Products fees on this eBay page: http://pages.ebay.co.uk/help/sell/fees.html.

As you see, there are 6 bands..

I have made this:

=IF(D3<29.99,SUM(D3*0.0525),IF(D3<99.99,SUM(D3-29.99)*0.03)+1.57)

However, when I try to add in band 3 by using this:

=IF(D3<29.99,SUM(D3*0.0525),IF(D3<99.99,SUM(D3-29.99)*0.03+1.57),IF(D3<199.99,SUM(D3-99.99)*0.025+3.67)

I get the error “Forumla is missing an emphasis”, or #VALUE

Any suggestions? Thank you