Jul 19 2018
08:40 PM
- last edited on
Jul 31 2018
08:46 AM
by
TechCommunityAP
Jul 19 2018
08:40 PM
- last edited on
Jul 31 2018
08:46 AM
by
TechCommunityAP
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
Jul 20 2018 06:58 AM - edited Jul 20 2018 07:04 AM
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)