IF (ISBLANK) checking more than one cell
I'm a beginner and trying to update this formula below to also produce a blank result if Reach@row is blank.
=IF(ISBLANK([Total Engmt]@row), " ", ([Total Engmt]@row / Reach@row))
Best Answer
-
Try this:
=IF([Total Engmt]@row <> "", IFERROR([Total Engmt]@row / Reach@row, ""))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
=IF(ISBLANK([Total Engmt]@row) = TRUE (or FALSE, depending on what you want), " ", ([Total Engmt]@row / Reach@row))
This is the correct format for the formula!
-
This doesn't address if Reach is blank. The formula I have works to return a blank cell if Total Engmt is blank, but I also need it to return a blank cell if Reach is blank. As I have it now, I get an error "#DIVIDE BY ZERO" if Reach is blank.
-
Try this:
=IF([Total Engmt]@row <> "", IFERROR([Total Engmt]@row / Reach@row, ""))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!