Help with formula?

[Bianca_Kearney]

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.

[Sho · Accepted solution]

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]

Thank you so much!