I am trying to write a formula to calculate selling fees. We are now able to sell using fixed price auctions on eBay, and eBay has just changed their fee structure - plus we also sell on an eCommerce site. So we have 3 possible fee structures. I have the following formula to calculate the new eBay fees, and aside from returning "FALSE" if W3 is blank, it works fine for an item listed as an auction:
=IF(W3="Auction",IF(L3<=9.99, 0.25, IF(L3<=24.99, 0.5, IF(L3<=49.99, 0.75, IF(L3<=199.99, 1, IF(L3>=200, 2,""))))))
What I need is for the formula to look at cell W3 and do the following:
If W3=blank, return a blank cell
If W3="Auction", do the fomula above
If W3="Fixed", return "0.20"
If W3="BC", return "0.00"
BTW, cell W3 has data validation to ensure only 1 of the 3 values listed. I also need to update my final value fee formula to do pretty much the same thing, but I think if I can get this one resolved I'll be able to apply it to the other.
Thanks!
=IF(W3="Auction",IF(L3<=9.99, 0.25, IF(L3<=24.99, 0.5, IF(L3<=49.99, 0.75, IF(L3<=199.99, 1, IF(L3>=200, 2,""))))))
What I need is for the formula to look at cell W3 and do the following:
If W3=blank, return a blank cell
If W3="Auction", do the fomula above
If W3="Fixed", return "0.20"
If W3="BC", return "0.00"
BTW, cell W3 has data validation to ensure only 1 of the 3 values listed. I also need to update my final value fee formula to do pretty much the same thing, but I think if I can get this one resolved I'll be able to apply it to the other.
Thanks!