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.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!