Return Values

[andysmeth]

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

 

[ExceLoki]

Book1
	A	B	C	D	E	F	G	H	I	J
1	Escalate									Terminate
2	Escalate									Transfer
3	Action Required									Treat
4	Action Required									Tolerate
5	Action Required									Combination
Sheet1

Cell Formulas
Range	Formula
A1:A5	A1	=IFS(OR(J1="Terminate", J1="Transfer"),"Escalate",OR(J1="Treat",J1="Tolerate",J1="combination"),"Action Required")

 

[andysmeth]

Book1
	A	B	C	D	E	F	G	H	I	J
1	Escalate									Terminate
2	Escalate									Transfer
3	Action Required									Treat
4	Action Required									Tolerate
5	Action Required									Combination
Sheet1

Cell Formulas
Range	Formula
A1:A5	A1	=IFS(OR(J1="Terminate", J1="Transfer"),"Escalate",OR(J1="Treat",J1="Tolerate",J1="combination"),"Action Required")

thank you!! worked a treat!

 

[andysmeth]

=IFS(OR(J1="Terminate", J1="Transfer"),"Escalate",OR(J1="Treat",J1="Tolerate",J1="combination"),"Action Required")

sorry how do I include if the cell is blank it shows nothing?

 

[ExceLoki]

=IFERROR(IFS(OR(J1="Terminate", J1="Transfer"),"Escalate",OR(J1="Treat",J1="Tolerate",J1="combination"),"Action Required"),"")

 

[andysmeth]

perfect thank you!

 

[ExceLoki]

glad to help, and welcome to mrexcel!