=IF(ISERROR(FIND("Dir",I94)),125,0)

"Audrey G." wrote:

Have a spreadsheet with following data:

Emp Name Title Bonus
John A Div Dir I
Jane B Div Dir IV
Mark C Tech
Mary D Admin

I want to create a conditional formula that under Bonus that looks at the
title, and for every position that contains "Dir" will be 0, while other
titles will be $125. Currently, my formula looks like this =IF(I94="Div Dir
I*"),0,125). However the result is coming out as $125. I need to know how
to adjust the formula to use a partial text word match.

Thank you,
Audrey G.