Forum Discussion
Formula Ideas
Hello! I have a spreadsheet I am having brain fog getting a formula. In the attached image in cell D2, I need a formula that will result in FALSE if the range E2:K2 shows numbers in any of the cell...
In D2:
=ISERROR(--CONCAT(E2:K2))
or as an array formula confirmed with Ctrl+Shift+Enter:
=OR(ISTEXT(E2:K2))
Fill down.
Thank you!! That works perfectly!