IF function using partial text

  • Thread starter Thread starter DCordova
  • Start date Start date
D

DCordova

I need to know how to set up an individual function using
part of a word like: =IF(b9="eng*",c9,0) where if
anything in cell b9 has eng in text line: ENGineer or
ENG0001234 then the statement is true.
 
Aladin Akyurek said:
=IF(COUNT(SEARCH("eng",B9)),C9,0)
Click to expand...
....

Doesn't anchor the sought substring to the beginning of the full string. It
could be done to OP's specs with one fewer function call.

=IF(COUNTIF(B9,"ENG*"),C9,0)

or getting terse

=COUNTIF(B9,"ENG*")*C9
 
Definitely.

Harlan Grove said:
...

Doesn't anchor the sought substring to the beginning of the full string. It
could be done to OP's specs with one fewer function call.

=IF(COUNTIF(B9,"ENG*"),C9,0)

or getting terse

=COUNTIF(B9,"ENG*")*C9
Click to expand...
 
Back
Top