IFTEXT vs something for numbers not just text
Hello Community,
I am using an IFTEXT function to automatically check a box in one column if the cell in another column(s) has text in it. I also need it to check the box when the other corresponding cells have, not only text, but numbers as well. Is it possible to combine the functions to allow for an "OR" command that includes numbers, for "anything in the cell" will trigger the box to be checked.
Thank you in advance,
Sarah Lee
Answers
-
Hi Sarah,
Try:
IF(NOT(ISBLANK()),
It returns true is the cell is not blank.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Ok, thanks for that Mark Cronk . Can you please review this formula for me.
Original formula:
=IF(OR(ISTEXT(pH@row), ISTEXT(EC@row), ISTEXT([High Temp]@row), ISTEXT([High Temp]@row), ISTEXT([Low Temp]@row), ISTEXT([Day RH%]@row), ISTEXT([Night RH%]@row)), 1)
New formula (Not working):
=IF(NOT(ISBLANK(pH@row), ISBLANK(EC@row), ISBLANK([High Temp]@row), ISBLANK([High Temp]@row), ISBLANK([Low Temp]@row), ISBLANK([Day RH%]@row), ISBLANK([Night RH%]@row)), 1)
I feel like the new formula needs to include "OR" somewhere and not sure if the ",1" needs to be there.
Thanks in advance,
Sarah
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!