Calculate eBay Final Value Fees

Hello,

I would like to create a formula in Excel to calculate my final value eBay fees. I know this is over kill but I have an idea and would like to see how accurate I can be. Is it possible to create a if...then type of formula that would first look at the value of the number and apply the eBay final value conditions below accordingly? If it can be done in Excel do you think it could be done in GOogle Docs or ZoHo (online spreadsheets). Any help is appreciated.

Thanks

The eBay final value fees are located at the link below.

http://pages.ebay.com/help/sell/fees.html

$0.01 - $25.00**

8.75% of the closing value

$25.01- $1,000.00

8.75% of the initial $25.00 ($2.19), plus 3.50% of the remaining closing value balance ($25.01 to $1,000.00)

Equal to or Over $1000.01

8.75% of the initial $25.00 ($2.19), plus 3.50% of the initial $25.01 - $1,000.00 ($34.12), plus 1.50% of the remaining closing value balance ($1000.01 - closing value)

If the closing value is in D2 try this formula, rounds to the nearest cent

=ROUND(D2*1.5%+MIN(D2,1000)*(3.5%-1.5%)+MIN(D2,25)*(8.75%-3.5%),2)

Thanks Daddylonglegs,

I've tested your formula and it works perfectly! Unfortunately I can't use it at Zoho but I have question posted there asking if I can replicate your formula over there.

Thanks again!

I know nothing about ZoHo, what stops that formula working there, do you know?

There are several other ways you could approach this, just IF functions for instance, would that work?

My mistake,

A little more tinkering in ZoHo and your formula works perfectly just the way it is.

Thanks again for your speedy response. VERY HELPFUL!!!

Cheers!

Mark