whats the equation for final value fee and paypal fees in excel

halil

Im making my own ebay spreadsheet, and i want excel to calculate the final value fee and the paypal fees automatically, but dont know the equation.
any ideas?

cheers

masonic

halil wrote:

Im making my own ebay spreadsheet, and i want excel to calculate the final value fee and the paypal fees automatically, but dont know the equation.
any ideas?

It's probably least confusing if you work each one out in a cell on the spreadsheet then add them on in another cell. So...

For the Paypal fees (easy!) you just want the formula "=0.2+TOTAL*0.034", where total is a cell ref to the final value in £.

The Ebay FVFs are a bit trickier. You will need to use some nested "if" statements... "=If(TOTAL<30, TOTAL*0.0525, If(TOTAL<600, 1.575+(TOTAL-30)*0.0325, 20.1+(TOTAL-600)*0.0175))"

Hopefully you can see what I've done there. The if statement works like: If(TEST, DO THIS, ELSE DO THAT), so you can link them together for more than two options. The 1.575 is the total fees payable on the first £30 and the 20.1 is the total fees payable on the first £600 (if you ever get that high!)

The listing fee will be in the same style as the FVF, but with more entries, so I'll leave you to ponder that! :eek:, eh!

halil

thanks alot, sorted now.

Encantador

http://www.netoutpost.f2s.com/auction/