Forum Discussion
MasonJD
Oct 06, 2022Copper Contributor
Conditional formulas with multiple outcomes
Hey guys, Trying to write a costing calculator, however I'm getting stuck using IF, AND, and OR. We have a set of products, some are eligible for discount, and some are not. Those that are eligib...
Martin_Weiss
Oct 06, 2022Bronze Contributor
Hi MasonJD
if I understood everything correctly, this could be a solution:
Please note, that you need the replace ; with , in all formulas, based on your local regional settings.