Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Two different pricing structures based on Multiple Select field

Topic Labels: Formulas
108 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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