View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
biol57 biol57 is offline
external usenet poster
 
Posts: 1
Default Is there a way to apply a sliding percentage?

Hi,

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

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

Thanks in advance

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