Need assistance modifying a formula

[kcleere]

I'm currently using the formula below to return the value in C4 if the text in K4 "contains the phrase" "BRANCH DEPOSIT" anywhere in the string.

I need to expand the formula to also return the C4 value if it finds "BRANCH DEPOSIT" OR "TRSF" anywhere in the K4 text string.

I have not been successful at adding the second condition.

= IF(COUNTIF(K4,"*BRANCH DEPOSIT*"),C4,"")

Thanks in advance.

K

 

[BarryL]

so theoretically gaz the below should also work?

=IF(SEARCH("Branch Deposit",K4)<>"",C4,IF(SEARCH("TSRF",K4)<>"",C4,""))

 

[gaz_chops]

so theoretically gaz the below should also work?

=IF(SEARCH("Branch Deposit",K4)<>"",C4,IF(SEARCH("TSRF",K4)<>"",C4,""))

Hi Barry, no that won't work.
The search function returns a number which refers to the position of the 1st character it finds in the search string, if it doesn't find the search value it returns #VALUE!
That formula will work if it finds "Branch Deposit", but if it doesn't it will return the error #VALUE! (It won't get to the 2nd If statement).
By using e.g. ISNUMBER it returns "True" or "False" so if it sees an error it returns "False" and will go to the 2nd IF statement.

Hope that makes sense.

Gaz