Checking Text Across A Range

[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

 

[SamuelT]

Sorry - I meant =IF(FE2:FJ2)="No","No","Yes")

Long day...

Samuel

 

[swatsp0p]

Try:

=IF(COUNTIF(FE2:FJ2,"=no")>0,"No","Yes")

Good luck

 

[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

 

[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",""))