how do I use ""or"" on a commission calculation formula?
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!
Forum Discussion
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.
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.