Forum Discussion
si.conjunto en mac
Hello, good evening, I need your help please; I spent 2 hours trying to make a formula in mac of si.joint and I get the error of circular formula and / or, # N / A since I tried everything and I can not get the formula I need.
The caluclo that I have to do is
Net price + shipping + commissions = gross price; but the commission is if it is ≤ $ 500; then gross price * 1.17 or if the net price is ≥ $ 1000 then the net price * 1.14 etc
Please your support, thank you very much1 Reply
Can you please clarify what is supposed to happen if both conditions are true? Is the below assessment accurate?
1. If Commission <= 500 Then ( Net Price + Shipping + Commissions ) * 1.17
2. If Net Price >= 1000 Then (Net Price *1.14 + Shipping + Commissions )
3. If Commission <= 500 and Net Price >= 1000 Then (Net Price * 1.14 + Shipping + Commissions)*1.17
4. If Neither Conditions are true Then (Net Price + Shipping + Commissions)
