Home > Back-end >  ARRAYFORMULA option for checking for cell values on each row of Google Sheet
ARRAYFORMULA option for checking for cell values on each row of Google Sheet

Time:05-20

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!): enter image description here

  • Related