'ARRAYFORMULA option for checking for cell values on each row of Google Sheet

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?

SAMPLE SHEET (blanks!): https://docs.google.com/spreadsheets/d/1M8ziq4he1oM0xiQ5JqbH2Y2t8UgkQfd8KIhmAFIesoc/edit#gid=109329290



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source