IF function using partial text

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.
 
H

Harlan Grove

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
 
A

Aladin Akyurek

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple AND OR functions 5
Page numbering with Merged Document and IF statements 1
Combine an And OR function 4
VBA-User says active cell jumps to a different sheet upon Save. Please review my code 1
Return a value if a range of cells contain text 2
Highlight rows if column A matches but B is different 0
IF & OR functions 5
Word OLE to check spelling in text box 1

Top