Forum Discussion
solucionesmarman
Jul 20, 2018Copper Contributor
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 ...
Matt Mickle
Jul 20, 2018Bronze Contributor
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)