Skip to main content

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

Hi Matteo, try this:


IF(

  FIND("20", Status),

  20,

  IF(

    FIND("40", Status),

    40

  )

)

Reply


Terms & Conditions