Hiya
I have a formula which works great
=IF(OR(ISNUMBER(SEARCH("Terminate",J9)),ISNUMBER(SEARCH("Transfer",J9))),"Escalate","")
I'm wishing to add more in the same cell but for a different return value. How can I do this please?
I wish to add
Treat returns Action required
Tolerate returns Action required
Combination returns Action required
I have a formula which works great
=IF(OR(ISNUMBER(SEARCH("Terminate",J9)),ISNUMBER(SEARCH("Transfer",J9))),"Escalate","")
I'm wishing to add more in the same cell but for a different return value. How can I do this please?
I wish to add
Treat returns Action required
Tolerate returns Action required
Combination returns Action required