Using nested ISBLANK
I would like build a nested ISBLANK equation that looks at two cells and if both are blank, then give "X", if one of the two cells is blank gives "Y" if neither are blank results in "Z".
I tried
Answers
-
Guy,
You may want to use a count formula for this. Here's what worked for me:
=IF(COUNT([Column2]@row:[Column3]@row) = 0, "X", IF(COUNT([Column2]@row:[Column3]@row) = 1, "Y", IF(COUNT([Column2]@row:[Column3]@row) = 2, "Z")))
Best,
Heather
-
Hi Heather,
Thanks for this. Makes perfect sense. However I am getting #unparseable:
=IF(COUNT([Subject15]@row:[Subject17]@row) = 0, "X", IF(COUNT([Subject15]@row:[Subject17]@row) = 1, "Y", IF(COUNT([Subject15]@row:[Subject17]@row) = 2, "Z")))
Thanks again.
-
Guy,
I don't see any errors in your formula. I changed my headers to match yours, and they are identical. Try copying and pasting this:
=IF(COUNT([Subject15]@row:[Subject17]@row) = 0, "X", IF(COUNT([Subject15]@row:[Subject17]@row) = 1, "Y", IF(COUNT([Subject15]@row:[Subject17]@row) = 2, "Z","")))
Also, feel free to provide a screenshot and block any sensitive information. That may help identify the issue.
Best,
Heather
-
Heather,
Thank you very much for the speedy reply. No luck. Image below:
-
Heather,
Got it...:)
=IF(COUNT(Subject5:Subject7) = 0, "Nothing Scheduled", IF(COUNT(Subject5:Subject7) = 1, "One Spotlight Scheduled", IF(COUNT(Subject5:Subject7) = 2, "Two Spotlights Scheduled", "")))
Thanks!
Guy
-
Ah! The @row got in the way! Nice catch.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!