
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 03, 2023 12:20 PM
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.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 03, 2023 03:30 PM
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
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 03, 2023 03:30 PM
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
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 06, 2023 01:50 PM
Thank you so much!
