Home  >  Community  >  The eBay Outlook  >  I need an excel equation for this . . .


<< previous topic post new topic post reply next topic >>
 imagecomposer
 
posted on October 21, 2001 07:44:43 PM
Here's how you calculate your Final Value Fee (if you sold real estate, see below): If your item sold for $25 or less, your Final Value Fee is 5% of the final sale price.

If you item sold for more than $25, please follow the next steps:
Take 5% of the first $25 of your final sale price.

Take the additional amount from $25.01 to $1,000, and calculate 2.5% out of that amount.
If your item did not sell for more than $1,000, please add your calculated results from step 1 & 2. This will be your final value fee.

If your final value was more than $1,000, take that additional amount and calculate 1.25% of the remaining amount.

Add the amounts together, from steps 1, 2, and 3, and you have your Final Value Fee!


HOW CONFUSING IS THAT????

 
 richierich
 
posted on October 21, 2001 08:01:18 PM
This is the formual I use to calculate FVF.

=IF(columnrow>25,sum(((columnrow-25)*2.5%)+(25*5%)),columnrow*5%)

Be sure to replace column with your column letter and row with the row number.

Let me know if you have a problem.

[ edited by richierich on Oct 21, 2001 08:16 PM ]
 
 imagecomposer
 
posted on October 21, 2001 10:12:59 PM
RICHIERICH - Thanks a lot!!!

It works perfect!!!

Thanks

PS - If you ever have a need a digital camera
contact me and I'll hook you up.



 
 richierich
 
posted on October 21, 2001 10:33:56 PM
imagecomposer - You must have missed my thread titled Sony MVD-FD17 HELP earlier this week. I think my problem is solved but I will not believe it until Sony receives the broken camera back and only charges me the $171 that they said.

Need any more help let me know. Do you need a listing fees formual? If so email me at [email protected]

 
 ebaypowersellergold
 
posted on October 22, 2001 09:02:55 AM
richierich, your equation only works for sales below $1,000. You actually need nested "IF" functions to handle higher amounts.

Here is the equation you should use. It will work for any final selling price.

=IF(A1<=25,A1*0.05,IF(A1<=1000,(A1-25)*0.025+1.25,(A1-1000)*0.0125+25.625))

Substitute the cell you want to calculate the FVF on for "A1" in the above equation. Remember to set the "format" to round to 2 decimal places...

 
 
<< previous topic post new topic post reply next topic >>

Jump to

All content © 1998-2025  Vendio all rights reserved. Vendio Services, Inc.™, Simply Powerful eCommerce, Smart Services for Smart Sellers, Buy Anywhere. Sell Anywhere. Start Here.™ and The Complete Auction Management Solution™ are trademarks of Vendio. Auction slogans and artwork are copyrights © of their respective owners. Vendio accepts no liability for the views or information presented here.

The Vendio free online store builder is easy to use and includes a free shopping cart to help you can get started in minutes!