# Discussions

View Only

## how do I use ""or"" on a commission calculation formula?

• #### 1.  how do I use ""or"" on a commission calculation formula?

Posted 06-01-2017 14:11
I'm calculation commissions. I'm trying to use a formula that says;
if ( [carrier x] or [carrier y] or [carrier z] , [monthly premium]*[health plan commission])
Thanks!

• #### 2.  RE: how do I use ""or"" on a commission calculation formula?

Posted 06-01-2017 14:13
Try this
IF(
[carrier] = "Carrier x"
or
[carrier] = "Carrier y"
or
[carrier] = "Carrier z", [monthly premium]*[health plan commission])

• #### 3.  RE: how do I use ""or"" on a commission calculation formula?

Posted 06-01-2017 14:17
i should also mention that the above formula will calculate to null if its not either of those carriers.

So its is probaly betetr to use
Try this
IF(
[carrier] = "Carrier x"
or
[carrier] = "Carrier y"
or
[carrier] = "Carrier z", [monthly premium]*[health plan commission],0)

or else if you run a total of the column it will be blank.

• #### 4.  RE: how do I use ""or"" on a commission calculation formula?

Posted 06-01-2017 14:24
Thank you! I'm testing right now.