Hello again - I'm trying to get column I of the attached spreadsheet to calculate selling fees at a product level, and there are (apparently) one or more issues with the following formula:
=IF(C2="eBay" and D2>=.01 and <=25,D2*.0525,IF(C2="eBay" and D2>=25.01 and <=1000,1.31+(.0325*D2-25),IF(C2="eBay" and D2>=1000.01,33+(.015*D2-1000.01),0)))
It is supposed to look at the value in column c, and if the product is listed in our eBay store it should calculate the selling fee based on the following:
Final Value (Selling) Fees
Closing Price Final Value Fee
>= $0.01 and <= $25.00 5.25% of the closing value
>= $25.01 and <= $1,000.00 5.25% of the initial $25.00 ($1.31), plus 3.25% of the remaining closing value balance ($25.01 to $1,000.00)
>= $1,000.01 5.25% of the initial*$25.00 ($1.31), plus 3.25% of the initial*$25.01 -*$1,000.00 ($31.69), plus 1.50% of the remaining closing value balance ($1000.01 - closing value)
I've attached a sample of the data I'm working with. If someone could point out the problem(s) with the formula above I'd really appreciate it. Thanks in advance.
Marcus
Bookmarks