Return text based on differnt text in a range

[osaben]

I would like to have a cell display the text "Process" if all of the cells in a range contains the word "Yes". Any of the cells in that same range contain the text "No" then have the cell display the text "Stop". And finally if any of the cells in a range contain "select one", the have the cell display nothing.

Thank you!

 

[mumps]

We would need some more information to help. In what column do you want to display "Process" or "Stop" or nothing? I assume that the range to search would be in the same row as the word "Process". What is the search range than contains "Yes', "No" or "select one"? If you could post a screen shot of your sheet, that would help or describe in more detail the organization of your data.

 

[DRSteele]

This might help. It is a nested IF statement so it's ugly, but it works.

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]

Book1
	B	C	D
1	process	Stop
2
3	range1	range2	range3
4	yes	no	no
5	yes	yes	yes
6	yes	yes	yes
7	yes	yes	select one
8	yes	yes	yes
9	yes	no	no
10	yes	yes	yes
11	yes	yes	select one
12	yes	yes	yes
13	yes	yes	yes
14	yes	no	no
Sheet31

Cell Formulas
Range	Formula
B1	=IF(COUNTIFS(B4:B14,"select one")>0,"",IF(COUNTIFS(B4:B14,"no")>0,"Stop",IF(COUNTIFS(B4:B14,"yes")=COUNTA(B4:B14),"process","other")))

[/FONT]

 

[osaben]

Thank You DRSteele! This worked perfectly!

 

[DRSteele]

Super. You're welcome.