| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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")) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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")) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP using FALSE returning blanks and #N/A | Excel Worksheet Functions | |||
| Returning a value rather than TRUE or FALSE. | Excel Discussion (Misc queries) | |||
| lookup returning true or false | Excel Discussion (Misc queries) | |||
| Returning nothing if formula is false | Excel Discussion (Misc queries) | |||
| VLOOKUP returning value when range_lookup false | Excel Worksheet Functions | |||
Linear Mode
