How do I make the following formula shorter:
return the value if it's a number, zero otherwise.
=IF(ISNUMBER(IMPORTRANGE("https://docs.goo.....5qLKqjw", "Data!I4:I"), IMPORTRANGE("https://docs.goo.....5qLKqjw", "Data!I4:I"), 0)
Google sheets IFNUMBER is missing
Viewed 47
2 Answers
The answer by basic will work for just a single cell.
This means one would have to use the IMPORTRANGE formula multiple times (once for each cell)
As an alternative one can use an ArrayFormula like
=INDEX(N(IMPORTRANGE("https://docs.goo.....5qLKqjw", "Data!I4:I")))
OR
=INDEX(IFERROR(IMPORTRANGE("https://docs.goo.....5qLKqjw", "Data!I4:I")^1,0))
Functions used:
Related