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

  • 1
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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!
Photo of David Dziewit

David Dziewit

  • 220 Points 100 badge 2x thumb

Posted 1 year ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
Try this
IF(
[carrier] = "Carrier x"
or
[carrier] = "Carrier y"
or
[carrier] = "Carrier z", [monthly premium]*[health plan commission])
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
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.
Photo of David Dziewit

David Dziewit

  • 220 Points 100 badge 2x thumb
Thank you! I'm testing right now.