=ArrayFormula({"Test"; query(value(CTA!C2:C)*0.8)})

How would I exclude the rest of the 0's in empty cells?

CodePudding user response：

try:

=ARRAYFORMULA({"Test"; IFERROR(1/(1/(VALUE(CTA!C2:C)*0.8)))})

or:

=ARRAYFORMULA({"Test"; QUERY(VALUE(CTA!C2:C)*0.8; "where Col1 <> 0"; )})

CodePudding user response：

Use INDEX COUNTA to constrain the input:

=ARRAYFORMULA({Test;CTA!C2:INDEX(CTA!C:C,COUNTA(CTA!C:C))*0.8})