Here is an ebay fee calculator Im working on. I cant seem to find an easy way to calculate the ebay fee column and paypal fee column but someone has helped with the shipping columnand i would like the other two to be similar.
Shipping Cost-
=IF(ISNA(VLOOKUP(H6,Shipping!C:H,6,FALSE)),"",VLOOKUP(H6,Shipping!C:H,6,FALSE))
CORRECT^^^^^^^^^^
Ebay Fees-
Takes The listing price (S) then depending on 'Category' (D) refers to Ebay Fees Sheet 3 and adds listing fee plus closing fee plus if >$50 plus >$1000 plus >$3000
Listing S&H is not calculated in this
Paypal
Takes 'Total Inflow' (V) and and adds listing fee and if >50, >3000,etc like above but listing s&H included
These are the only columns i need help with. Thanks
Bookmarks