Search code examples
google-sheetsarray-formulasgoogle-sheets-querygoogle-query-languageimportrange

Importrange doesn't work when last digit is 0 in a number

When I import 35% discount from my google sheet, it works; but when I want to import 40% discount, it doesn't work. Why?

Solution 
  • =ARRAYFORMULA(QUERY(TO_TEXT(IMPORTRANGE(
 "10UIQseUBLhJ3BRI-pOqROvYtSbWNCRrj054LGH0peDE", "All Books!B2:L")), 
 "where Col11 contains '40' limit 10", 1))

    0