Using nested ISBLANK

Guy Paterson

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

Heather Duff

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

Guy Paterson

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.

Heather Duff

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

Guy Paterson

Heather,

Thank you very much for the speedy reply. No luck. Image below:

Guy Paterson

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

Heather Duff

Ah! The @row got in the way! Nice catch.