Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

IF Contains Formula

Topic Labels: Formulas
3009 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Matteo_Saporett
5 - Automation Enthusiast
5 - Automation Enthusiast

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