I want to create a formula or expression to: look inside a cell and detect if a particular text string exist, so I can use this condition to trigger a subsequent formula execution.
For example:
I have original cell content as:
=Pill 1, Pill 2, MC, DC
I want to tell the second cell to look for “Pill 1″ and in case to find it, go ahead and execute some simple mathematical expression.
Hi Nelson,
You can use following formula to solve your problem,
=IF(ISNUMBER(SEARCH(”esp”,D8)),2*3,”")
Above formula out puts 6 by executing 2*3 if it finds string “esp” in cell D8. Type above formula manually, do not copy paste it.
Hello,
I want to create a formula or expression to: look inside a cell and detect if a particular text string exist, so I can use this condition to trigger a subsequent formula execution.
For example:
I have original cell content as:
=Pill 1, Pill 2, MC, DC
I want to tell the second cell to look for “Pill 1″ and in case to find it, go ahead and execute some simple mathematical expression.
Thanks in advance,
Nelson
Hi Nelson,
You can use following formula to solve your problem,
=IF(ISNUMBER(SEARCH(”esp”,D8)),2*3,”")
Above formula out puts 6 by executing 2*3 if it finds string “esp” in cell D8. Type above formula manually, do not copy paste it.
Hope this resolves your problem.