Help

Help with formula?

Topic Labels: Formulas
Solved
Jump to Solution
817 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
)

Thank you so much!