I would like to use an ARRAYFORMULA check if a series of cells is blank/contains a number for each row. if all five columns of a row contain a number, I would like the check column to indicate TRUE. If any one of the five columns of a row are blank, I would like the check column to indicate FALSE.
While the current use references number values, I am interested in a potential blank value option for future cases that may include string data.
I have two working "dragdown" options using AND ISNUMBER and NOT OR ISBLANK—each with an internal ARRAYFORMULA.
=AND(ArrayFormula(ISNUMBER(B2:F2)))
=NOT(OR(ArrayFormula(ISBLANK(B2:F2))))
Is there a single formula that would not require dragging when new values are added?