Google Sheet Array Formula Put blank

I have this formula

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

enter image description here

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

>Solution :

try:

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

enter image description here

Leave a Reply