Help with formula? | Airtable Community

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.

Page 1 / 1

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

)

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!

Sign up