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 there are any "no's" in the range, and a blank response if the range is blank.
Any suggestions?
3 Replies
- SergeiBaklanDiamond Contributor
- cjohns125Copper Contributor
That worked perfect, thank you!
- SergeiBaklanDiamond Contributor
cjohns125 , you are welcome