Search code examples
arraysif-statementgoogle-sheetsarray-formulasnested-if

Arrayformula Int

How would I adjust this formula to not expand to infinity, but only expand if the adjacent row contains a value?

=ARRAYFORMULA({"Invoice Date"; INT(B2:B)})

thanks!

Solution

  • like this:

    =ARRAYFORMULA({"Invoice Date"; IF(A2:A="";;INT(B2:B))})