# eBay Calculator Formula Help

1. ## eBay Calculator Formula Help

Hi there

I am trying to create a formula that will give the total of the eBay fees based on the sale price.

The fees are as follows. 11% of the selling price if the item is below \$50, or if the selling price is \$50 or above they charge the 11% up to 50% (\$5.50) and then 6% of the remainder.

I have the sellling price in one column - P3, and I can do seperate formulas for each of the above, however I need to create one formula so it automatically recognises if the selling price is less than or greater than \$50 and works out the fees that will be charged.

I hope that makes sense and any help would be appreciated.

Thanks
Phil  Register To Reply

2. ## Re: eBay Calculator Formula Help

Not sure if I've understood the breakpoints correctly.

If this isn't correct,please provide examples of payment and the interest you would expect to pay.

For example, \$10, \$25, \$49, \$50, \$60, \$100.

Regards, TMS  Register To Reply

3. ## Re: eBay Calculator Formula Help

Hi there

For example.

If I sell an item for \$40 - ebay will change me a straight 11% as it is under \$50 = \$4.40

If I sell an item for \$90 - ebay will change me 11% of the total up to \$50 (\$5.50) and then 6% of the remaining \$40 (\$2.40). Total fees in this case would be \$5.50+\$2.40 = \$7.90

I want to be able to enter just the sell price in a cell and a formula will calculate the fee.

Thanks
Phil  Register To Reply

4. ## Re: eBay Calculator Formula Help

See if this works for you.  Register To Reply

5. ## Re: eBay Calculator Formula Help

Fantastic! Thanks for your quick help. That does the trick.

Phil  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 