Help

Two different pricing structures based on Multiple Select field

Topic Labels: Formulas
682 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Peter_Bovenmyer
4 - Data Explorer
4 - Data Explorer

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

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}
  )
)