Yes if range contains text, no if not, and blank if range is blank

[cjohns125]

I have a spreadsheet with ranges by date containing "yes" and "no" responses. I need a formula to look at the range, assign a "Yes" response if there are no "no"s in the range, a "No" response if there are any "no's" in the range, and a blank response if the range is blank.

Any suggestions?

[#2]

@cjohns125 , that could be

=IF(COUNTA(<range>),IF(COUNTIF(<range>,"no"),"no","yes"),"")

[#3]

@Sergei Baklan 

That worked perfect, thank you!

[#4]

@cjohns125 , you are welcome