Skip to main content
Question

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

  • June 1, 2017
  • 0 replies
  • 50 views
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!
      This topic has been closed for replies.

      Try this
      IF(
      [carrier] = "Carrier x"
      or
      [carrier] = "Carrier y"
      or
      [carrier] = "Carrier z", [monthly premium]*[health plan commission])
      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.
      • DavidDziewit
      • Author
      • Registered
      • June 1, 2017
      Thank you! I'm testing right now.
      Terms & ConditionsAccessibility statement