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

+11

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

+27

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

+11

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

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

Sign up