Forum Discussion

cjohns125's avatar
cjohns125
Copper Contributor
Apr 26, 2019

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

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 the...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 26, 2019

cjohns125 , that could be

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

 

Resources