I have this formula

=ArrayFormula(IF(LEN(C$3:F$3), H4:L4 C4:F4/$C$1, ""))

How i can modify this array formula to return Blank like in I7?

CodePudding user response：

try:

=BYROW(B34:F38, LAMBDA(x, INDEX(SPLIT(TEXTJOIN(" ", 1, x), " "),,1)))