=ArrayFormula({"Test"; query(value(CTA!C2:C)*0.8)})
How would I exclude the rest of the 0's in empty cells?
Exclude 0's from arrayformula
cpaone
0
Viewed 36
2 Answers
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"; )})
Use INDEX+COUNTA to constrain the input:
=ARRAYFORMULA({Test;CTA!C2:INDEX(CTA!C:C,COUNTA(CTA!C:C))*0.8})
Related