How to represent this conditional formula?

#1

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!!

0 Likes

#2

Welcome to the forum! This should do the trick:

0.3 * IF(Split, {My Portion}, {Sale Total})
4 Likes

#3

Worked like a charm, thanks man!

1 Like