Help

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

Topic Labels: Formulas
1232 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Lisa_H
6 - Interface Innovator
6 - Interface Innovator

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.