si.conjunto en mac

Copper Contributor
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 much
1 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)