IF Contains Formula

[Matteo_Saporett]

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

[TheTimeSavingCo]

Hi Matteo, try this:

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