How do I return a Yes or No response?

[Ellasheba]

I want to look across a row of cells and if any one of them has some data in to cell it returns a yes or no return .. .
I am using counting to count how many cells have something in, but I want another return that doesn’t count ...
many thanks

 

[AliGW]

Something like this:

=IF(COUNTIF(range,criterion)>0,"Yes","No")

 

[Ellasheba]

Thank you I will try this out

 

[Ellasheba]

Hello I tried it but it only brings back no even when there is something in one of the cells ?

What should I be putting in the criterion part?

=IF(COUNTIF(A1:T1,criterion)>0,”Yes”,”No”)

 

[Hui]

=IF(COUNTIF(A1:T1,"<>")>0,"Yes","No")

That is a <> with " around them, no spaces

 

[Ellasheba]

Thank you Hui that’s worked perfectly! And to AliGW too !