Forum Discussion
cjohns125
Apr 26, 2019Copper Contributor
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...
cjohns125
Apr 26, 2019Copper Contributor
That worked perfect, thank you!
SergeiBaklan
Apr 27, 2019Diamond Contributor
cjohns125 , you are welcome