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?
Two different pricing structures based on Multiple Select field
+27Your 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}
)
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.