Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Question
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! |
#2
|
|||
|
|||
See newsgroup worksheet.functions . Please don't multipost.
HTH. Best wishes Harald. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
time formula question... | Excel Discussion (Misc queries) | |||
formula Question | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions |