# Thread: I need a formula to calculate eBay listing fees.

1. ## 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. 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. 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
•