The below should work but as Mike mentioned it is case sensitive. You can
also try the below

=IF(C2="","",IF(COUNTIF(C2,"*manager*"),15,5))

Mike, Sorry I just logged in to find this post unanswered. Since the time
zones are different couldnt identify that you were awaiting a response from
the OP...

If this post helps click Yes
---------------
Jacob Skaria


"Cloud Strife" wrote:

Now, everything in false statement...