LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
shadrach
 
Posts: n/a
Default Code Question - Calculate eBay Fees Automatically

I'm trying to create a spreadsheet that will help log eBay sales. I want to
set up a formula to figure the fees once an item is sold. I'm hoping to just
enter the final sale price and in another cell with the formula in it, figure
the eBay Final Value Fees. I've tried a bunch of times and cannot get the
code correct. The fees are figured in the following way:

1- Item not sold - No Fee

2. $0.01 €“ $25.00 - 5.25% of the closing value
$25.01 €“ $1,000.00 - 5.25% of the initial $25.00 ($1.31), plus 2.75% of the
remaining closing value balance ($25.01 to $1,000.00)

3. Over $1,000.01 - 5.25% of the initial $25.00 ($1.31), plus 2.75% of the
initial $25.00 - $1,000.00 ($26.81), plus 1.50% of the remaining closing
value balance ($1,000.01 - closing value)

Is it possible to do all that in just a single formula in one cell? I've
tried doing "IF" formulas, but can't seem to get it right. Even if it has to
be in a few cell, it's be fine. Any help would be great.

Thanks!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I automatically calculate YTD numbers by changing a date? MDSistah Excel Worksheet Functions 1 April 29th 05 05:52 PM
How do I make a chart that will automatically calculate my bills . melissto New Users to Excel 2 March 20th 05 07:15 AM
How do I make a chart that will automatically calculate my bills . melsto New Users to Excel 0 March 19th 05 05:43 PM
Make Change Case in Excel a format rather than formula Kevin Excel Worksheet Functions 1 March 18th 05 08:53 PM
syntax question - cell references in VB code needyourhelp New Users to Excel 1 March 2nd 05 08:52 PM


All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"