
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 22, 2022 07:50 PM
I want to write a formula that calculates percentages of a total sale price based on data within a multiple select field. Basically if an item is marked “commission” in the multiple select field the formula would calculate 30% of sale price. If marked “asset” in multiple select field the sale price would not change. Do I need to use an if statment to write this?
1 Reply 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jul 22, 2022 08:15 PM
Your formula will need to account for “commission” appearing at the start, end, or middle of the string. That can be done with regex, or more simply with either FIND() or SEARCH().
IF(
FIND("commission", {multiple select field}),
{sale price} * .3,
IF(
FIND("asset", {multiple select field}),
{sale price}
)
)
