Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Apply various percentage with sales between a & b, b & c, etc. | Excel Worksheet Functions | |||
Apply a percentage factor to a base number | Excel Worksheet Functions | |||
A formula for sliding scale percentage?????? | New Users to Excel | |||
Sliding Scale Percentage via IF? | New Users to Excel | |||
Percentage Commission on a sliding scale. | Excel Discussion (Misc queries) |