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 cells and TRUE if the range E2:K2 shows any text. Any help is much appreciated!
2 Replies
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!
