I’m trying to calculate a formula using the if function but not sure where to start. My formula correctly calculates the wholesale cost of a case of 12 bottles of imported wine from the ex cellar price. However, still wines under 14.10% Alc are taxed at 25% of the value (ex cellar x 1.25), still wines 14.1% and higher are not taxed, and to make things even more exciting, sparkling wines are never taxed. I want to make one formula that incorporates whether the wine is taxed or not. can anyone help?
in my formula: ex cellar = price of 1 bottle of wine in EUR, 1.15 = est exchange rate 1 EUR= USD, 12 = number of bottles in a case, 18 = cost of shipping in USD to import the wine, 0.6 = target 40% margin on final price.
everything works fine, just not sure how to incorporate the tariff on some wines but not others.