search for multiple strings
It works! Thank you so much!
"Gary Brown" wrote:
=IF(AND(ISERROR(SEARCH("move",D4)),ISERROR(SEARCH( "carryforward",D4))),0,E4)
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown
"Lea from CA" wrote:
Here is my current formula =IF(ISERROR(SEARCH("move",D4)),0,E4). Now I want
to also search for "carryforward" in cell D4. How can I do that?
|