Discussions

Expand all | Collapse all

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.