Results 1 to 3 of 3

20110224, 14:26 #1
 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))))))))))))

20110224, 15:34 #2
 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

20110224, 19:30 #3
 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.