Multiselect and Substitute formula

[DaleNorris]

Concept: 

I have 3 columns 

1.  i  have a multi-select field of Job Types as follows
   1. Aerial Display - Water / Barge
   2. Aerial Display - Land
   3. Close Proximity
2. I have a total invoice column in $ (approved spend)
3. I have a formula column with the current formula "

   IF({Job Type}="Aerial Display - Water / Barge", ({ApprovedSpend}-2000)*.27, {ApprovedSpend}*.27)

I have run into the issue that when the column 1 (job type) has more then just "aerial Display water/barge" selected it ignores the first, part of the formula. so I'd rather it be something along the lines of IFCONTAIN?

[Sho · Accepted solution]

Do you mean you want all "Aerial Display -" to be true?

IF(FIND("Aerial Display - ", {Job Type}),({ApprovedSpend}-2000)*.27, {ApprovedSpend}*.27)