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
Bookmarks