Checking Text Across A Range

S

SamuelT

Hello again,

I have a row (specifically FE2:FJ2) which has either "yes" or "no"
values in it. I want Excel to look across this range; if there are any
"no"s, I want to return a value of "no", if there are only "yes"s I
want to return a value of "yes".

I've been trying =IF(FE3:FJ3)="No","No","Yes"), but this just returns a
#VALUE.

Any ideas?

Thanks in advance,

SamuelT
 
S

SamuelT

Sorted it myself!

I actually only needed a value to conditionally format another column.
I've used COUNTIF instead. I count the "no"s, and if there are any,
then I conditionally format the other column to go red, for instance,
if the cell value is less than 0.

Sweet.

Thanks for all the viewings!

SamuelT
 
M

Max

Presuming that "Yes" is to be returned only if
all 6 cells within FE2:FJ2 contain "Yes", one way:

=IF(ISNUMBER(MATCH("No",FE2:FJ2,0)),"No",
IF(COUNTIF(FE2:FJ2,"Yes")=6,"Yes",""))
 
Top