celebrityskin
|
posted on July 29, 2001 10:42:27 AM new
Ok, some Excel help needed.
Auction Ending price is Cell C.
Ebay Final Value Fee in Cell I.
Is there a formula that would take $28.00 in cell C and give the proper Final Value fee in Cell I?
|
yumacoot
|
posted on July 29, 2001 10:58:37 AM new
You would have to build your formulas based on ebays FVF rate....the rates differ for different Final Values
|
sadie999
|
posted on July 29, 2001 11:22:01 AM new
Is there a formula that would take $28.00 in cell C and give the proper Final Value fee in Cell I?
eBay get 5% of the first $25 and
2.5% to the next $1000 I believe.
Let's say $28.00 is the value in cell C3, so 5% of that would be:
=.05*c3
But that's too much. The amount over $25.00 is: c3-$25
You want to deduct 2.5% of the overage from your original caluclation, so the formula would be:
=(.05*c3)-(.025(c3-25))
Someone check my math, but I think that will do it. It'd be more extensive if your items are over $1000, but that should work for up to that price.
|
celebrityskin
|
posted on July 29, 2001 11:28:41 AM new
Thanks Sadie... but that doesn't work..
Auction ends $15.00
Final Value fee is $.75
The Formula:
=(.05*c3)-(.025(c3-25)
Gives: .625
|
wbbell
|
posted on July 29, 2001 11:31:46 AM new
=MIN(1.25,F605*0.05)+MAX(0,(F605-25)*0.025)
That works when the item is $1000 or less.
|
sadie999
|
posted on July 29, 2001 11:31:55 AM new
You're right. It will only work with items that sell over $25.00.
I don't know how to do macros or if/then in excel. Sorry. 
edited to add: but fortunately wbbell does!
[ edited by sadie999 on Jul 29, 2001 11:32 AM ]
|
celebrityskin
|
posted on July 29, 2001 11:33:47 AM new
=MIN(1.25,F605*0.05)+MAX(0,(F605-25)*0.025)
Where would I put cell "C"?
That is the cell that my final auction amount is!
|
sadie999
|
posted on July 29, 2001 11:35:43 AM new
I'm guessing here, but F605 looks like a cell. So try substituting your cell for that.
|
wbbell
|
posted on July 29, 2001 11:37:04 AM new
Yes, F605 is the cell number from my spreadsheet. Change F605 to C3 or whatever you need it to be.
|
celebrityskin
|
posted on July 29, 2001 11:47:09 AM new
Got it. Just copied the formula down and away we go.
Many thanks to the auctionwatch board. Once again these fine folks have saved me alot of work!
Mod... you can close this. I'm happy.
[ edited by celebrityskin on Jul 29, 2001 11:47 AM ]
|
rarebourbon
|
posted on July 29, 2001 11:47:48 AM new
=IF(C3>25,1.25+((C3-25)*0.025),C3*0.05)
This will correctly calculate items selling for less than $1,000 where C3 is the final selling price.
Over $1000 needs a different formula.
rarebourbon
|
chenillec
|
posted on July 29, 2001 11:55:41 AM new
What about extra column/calculation for Paypal or merchant fees.
Papal: 2.2% + 30 cent each transaction.
Would it be....
MIN(2.2,D5*0.05)+MAX(0,(D5-25)*0.022+.30).
I know I am wrong here. Correct me please.
|
wbbell
|
posted on July 29, 2001 08:40:36 PM new
Chenillec, you don't need to get that elaborate for a non-tiered rate structure like paypal's. Just do it like:
=(C5*0.022+0.30)
-WBB
Or wait, shouldn't it be simply:
=0.0
Since paypal is always free?
Or wait, shouldn't we put a test in there for your having the "merchant rate"? Never mind, don't get me started.....
[ ubb ]
[ edited by wbbell on Jul 29, 2001 08:41 PM ]
|
chenillec
|
posted on July 29, 2001 08:55:59 PM new
LOL, Thank Wbbell for the tips. Sometime, I think everybody want money from me. Paypal, Ebay + mortage...
|
peiklk
|
posted on July 29, 2001 10:00:08 PM new
I've got a spreadsheet already worked out that will do FVF and Paypal.
If anyone wants it let me know.
|
mballai
|
posted on July 30, 2001 07:47:47 AM new
I put a FVF field in my database and have never used it. OTH, I deduct the commission off of my half.com sales in the sell price.
From an accounting standpoint, you are best subtracting your all your fees on a monthly basis from your monthly sales total. A lot simpler. Just because you can put something in a spreadsheet doesn't mean you should.
|
