Hi guys, I’m new to formulas and having trouble figuring out the correct formula for my needs.
I have 4 fields: Sale Total (Currency), Split (multiple select), My Portion (Currency), & Commission (Formula).
What I’m trying to get the Commision formula to do:
If Split field is empty (none selected) = Calculate 30% of sum from “Sale Total” field. But if there is anything at all selected in the Split field = Calculate the 30% from the “My Portion” field instead.
What is the formula to achieve this? Thanks in advance for your help!!