ExcelBanter - Returning a value if false

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Returning a value if false (https://www.excelbanter.com/excel-worksheet-functions/230777-returning-value-if-false.html)

James W

Returning a value if false

I have a spreadsheet that I am working on. It has a row that has either an X
or an O for about 30 days. I am trying to write a formula that will review
that row and give me a result of either Yes if there are all O's or No if
there are ANY X'S. I know this is something extremely simple to do but I cant
get it to work for the life of me.

Harlan Grove[_2_]

Returning a value if false

James W <James wrote...
I have a spreadsheet that I am working on. It has a row that has either an X
or an O for about 30 days. I am trying to write a formula that will review
that row and give me a result of either Yes if there are all O's or No if
there are ANY X'S. I know this is something extremely simple to do but I cant
get it to work for the life of me.

=IF(COUNTIF(range,"O")=COUNTA(range),"Yes",IF(COUN TIF(range,"X"),"No",
"something else"))

James W[_2_]

Returning a value if false

Works like a charm.... I really appreciate the help and the extremely quick
response!!!

"Harlan Grove" wrote:

James W <James wrote...
I have a spreadsheet that I am working on. It has a row that has either an X
or an O for about 30 days. I am trying to write a formula that will review
that row and give me a result of either Yes if there are all O's or No if
there are ANY X'S. I know this is something extremely simple to do but I cant
get it to work for the life of me.

=IF(COUNTIF(range,"O")=COUNTA(range),"Yes",IF(COUN TIF(range,"X"),"No",
"something else"))

All times are GMT +1. The time now is 10:58 AM.