Forum Discussion

DavidDziewit's avatar
DavidDziewit
Qrew Trainee
8 years ago

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!
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Try this
    IF(
    [carrier] = "Carrier x"
    or
    [carrier] = "Carrier y"
    or
    [carrier] = "Carrier z", [monthly premium]*[health plan commission])
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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.