Try J.E his examples

http://www.mcgimpsey.com/excel/taxvariablerate.html

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"biol57 " wrote in message ...
Hi,

I'm trying to use Excel to calculate final value fees for items we
sell on eBay. For example, eBay charges a sliding percentage, based on
the selling price. For $0-25.00 the percentage is 5.25 %, for $25.01 to
$1000, the percentage is 5.25 % of the first 25.00 and 2.75 % of the
remaining $25.01 to $1000. For sales of $1000.01 or more, eBay charges
5.25% of the first $25.00, 2.75% of $25.01 to $1000 and 1.50% of the
remaining sale over $1000.

I need to know if anyone has a solution that will allow me to put in
the gross sales $ and have the eBay fees calculated.

Thanks in advance !


---
Message posted from http://www.ExcelForum.com/