Is there a way to apply a sliding percentage?

[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

 

[Tom Ogilvy]

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.

 

[Ron de Bruin]

Try J.E his examples

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