Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Help with formula?

Topic Labels: Formulas
Solved
Jump to Solution
947 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Bianca_Kearney
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi I got help with this a little while ago and it was perfect but now I want to add to it and anything I try does not work.

This is relating to an commissions payable per situation.

IF(

  {Booked By} = 2,

  {Points Paid} * 0.04

)

The above works however I want to add more situations -

IF booked by 0 points paid is 0.00 

IF booked by 1 points paid is 0.03 OR

IF booked by 2  points paid is 0.04 OR

Thanks in advance.

 

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Hi @Bianca_Kearney ,

For simple conditional branching, the SWITCH function is easy to understand.

SWITCH({Booked By},
  2, {Points Paid}*0.04,
  1, {Points Paid}*0.03,
  {Points Paid}*0
)

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

Hi @Bianca_Kearney ,

For simple conditional branching, the SWITCH function is easy to understand.

SWITCH({Booked By},
  2, {Points Paid}*0.04,
  1, {Points Paid}*0.03,
  {Points Paid}*0
)
Bianca_Kearney
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you so much!