Is there a way to apply a sliding percentage?

  • Thread starter Thread starter biol57
  • Start date Start date
B

biol57

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
 
Create a lookup table with the cutoff values in the left column and the
corresponding percentage in the right most. You can then use the vlookup
function to get the percentage based on your selling price. See the help on
Vlookup for details. You would want a sorted table/lookup range.
 
Back
Top