You're welcome, Audrey - thanks for feeding back.

Pete

On Aug 13, 10:59*pm, Audrey G.
wrote:
Thank you so much! *You have saved me HOURS of work on a very LARGE set of
data!! * *Have a great day!
--
Audrey G.



"Pete_UK" wrote:
You can extend your search like this:

=IF(ISNUMBER(SEARCH("Dir",I94)),0,IF(ISNUMBER(SEAR CH("Proj Mgr",
0,125))

Hope this helps.

Pete

On Aug 13, 5:57 pm, Audrey G.
wrote:
Thank you for taking the time to respond. *Please see my reply to Jacob for
some additional assitance I am needing.
--
Audrey G.

"Pete_UK" wrote:
Use SEARCH or FIND, eg:

=IF(ISNUMBER(SEARCH("Dir",I94)),0,125)

FIND is case sensitive.

Hope this helps.

Pete

On Aug 13, 4:45 pm, 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.- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -