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.

IF Contains Formula

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

Hi all,

I need to create a formula column to calculate price of shipping equipments.
I have multiple equipment types in a single select column e.g. (20DV, 20OT, 40DV, 40HC, 40OT)

For all the “20” regardless if it’s DV or OT (same for the 40) the price is the same.

Therefore I need an IF statement kind of like IF Equipment contains “20”, price is …

thanks in advance

Matt

1 Reply 1

Hi Matteo, try this:

IF(
  FIND("20", Status),
  20,
  IF(
    FIND("40", Status),
    40
  )
)