Results 1 to 7 of 7

if statement Simplification

Threaded View

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

    Re: if statement Simplification

    The Ebay fees: (This is not a working formula, its simply showing what I want the formula to say.)
    ('Inventory!'X * 'eBay Fees'!H) + if > 50, add ('Inventory!'X * 'eBay Fees'!I) + if > 1000, add ('Inventory!'X * 'eBay Fees'!J) + 'eBay Fees'!G
    The row numbers are dependant on category shown ('Inventory'!D)
    This column is to show the Ebay fee which is then added to columns J through P.

    The Paypal Fee:
    ('Inventory'!X + 'Inventory'!Y) * 'eBay Fees'!H (2.9%) (2.5% if sum of 'Inventory'!X:Y > $3000)

    I dont know how to make it any simpler than that. Look at the formulas that are in the spreadsheet already to show where everything is suppose to point.Im including the two worksheets again. inv97-03.xls is the current one. ebay1.xls is my old one that works but you cant choose category (Column D) or or price variable
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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