Closed Thread
Results 1 to 1 of 1

more advanced ebay spreadsheet

  1. #1
    Registered User
    Join Date
    11-18-2008
    Location
    titicaca
    Posts
    11

    more advanced ebay spreadsheet

    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
    Attached Files Attached Files
    Last edited by sk81681; 05-12-2009 at 09:49 PM.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1