Is it possible to somehow pass the results of an array formular to another function with a scalar as a return value?

[tomjovi22]

I want to write a function that checks if all fields in a row have values in them. I know that I could do this manually like so:

=OR(ISBLANK($C2);ISBLANK($D2);ISBLANK($E2); ISBLANK($F2);ISBLANK($G2))

I do not like this approach as the formula gets very long and is only one part of an even longer formula. Also, I have to update it every time I insert columns in between.

Now my question is: Could I somehow solve this easier using a array formular?

I know that this returns an array with the values I need:
{=ISBLANK(C2:G2)}

At the same time OR() can also process arrays. But I can’t seem to be able to link those concepts together. Basically what I would want would be this:

=OR({ISBLANK(C2:G2)})

It should then return TRUE if any of the fields is empty. Unfortunately, that does not work. Does anyone have an idea how to maybe get it to work?

[JohnSUN]

Just type =OR(ISBLANK(C2:G2)) and press Ctrl+Shift+Enter instead Enter

[JohnSUN]

By the way,
=AND(SUMPRODUCT(ISBLANK(C2:G2)))
=OR(SUMPRODUCT(ISBLANK(C2:G2)))
will return same result (in this case AND() or OR() just convert number result to boolean)

[tomjovi22]

Thanks! It was so simple, but I just couldnt find it!