Results 1 to 5 of 5

Help with multiple IF and OR statements

Threaded View

  1. #1
    Registered User
    Join Date
    11-20-2010
    Location
    Warwick, RI
    MS-Off Ver
    Excel 2007
    Posts
    13

    Help with multiple IF and OR statements

    I'm trying to put together a formula for all of my ebay final value fees (which are entirely too complicated,) I think I have the basics down but the math does not come out right. Somebody please help.

    =IF(J13="YES",(IF(G13="Electronics",IF(L13<=50,L13*0.08,(OR(L13>=50.01,L13<=1000)*L13-50*0.05+(0.08*50))),IF(G13="Clothing",IF(L13<=50,L13*0.12,(OR(L13>=50.01,L13<=1000)*L13-50*0.09+(0.12*50))),IF(G13="Books",IF(L13<=50,L13*0.15,(OR(L13>=50.01,L13<=1000)*L13-50*0.05+(0.15*50))),IF(G13="Other",IF(L13<=50,L13*0.12,(OR(L13>=50.01,L13<=1000)*L13-50*0.06+(0.12*50)))))))),"NO")

    G13 = is the category for which the item belongs and then has a corresponding formula depending on the price sold

    J13 = asks me if the item was buy it now or not if yes then it just has to use the formulas that are listed

    L13 = price sold
    Last edited by Rooster35236; 11-22-2010 at 05:36 PM.

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