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.

How to write this IF statement so that it "contains" the Text instead of "=" the Text

Topic Labels: Formulas
505 2
Showing results for 
Search instead for 
Did you mean: 

I have a multi select menu for each job, and so each job may or may contain the GH option, by itself, or with other options.

I am trying to calculate Commission on jobs that CONTAIN GH.
The way I have it now, it only returns commission based on jobs that are ONLY GH.

Any help would be appreciated. Thank you!

IF(Type = “GH”, SUM({Paid (Sold)}*.1))

2 Replies 2

IF(FIND('GH', {Type}),SUM({Paid (Sold)})*.1)

Thank you!!!
Lol man I feel stupid now… IDK why I didn’t think about that.