Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Feb 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    I need a formula to calculate eBay listing fees.

    I use the following for calculating eBay listing fees when listing in one category. It works fine.

    =IF(E2>199.99,2,IF(E2>49.99,1,IF(E2>24.99,0.75,IF( E2>9.99,0.5,IF(E2>0.99,0.25,0.1))))))

    I need a formula to calculate fees when listing in two categories - the fees would be doubled.
    I want to use the "D" column to indicate 1 or 2 categories.
    I tried the following - it does not work - it states "The formula you typed contains an error."

    =IF(D2=1,IF(E2>199.99,2,IF(E2>49.99,1,IF(E2>24.99, 0.75,IF(E2>9.99,0.5,IF(E2>0.99,0.25,0.1,IF(D2=2,IF (E2>199.99,4,IF(E2>49.99,2,IF(E2>24.99,1.5,IF(E2>9 .99,1,IF(E2>0.99,0.5,0.2))))))))))))

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    You have too many nested IFs. What about:
    =IF(E2>199.99,2,IF(E2>49.99,1,IF(E2>24.99,0.75,IF( E2>9.99,0.5,IF(E2>0.99,0.25,0.1))))))*D2

    Steve

  3. #3
    New Lounger
    Join Date
    Feb 2011
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you Steve. Such a simple solution. Now I can go back and revise 4 spreadsheets.

Posting Permissions

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