Author Topic: Formula =B8<>"" should give TRUE when B8 contains a 0 character but does not  (Read 1652 times)

jaapmurre

  • Pro Deluxe
  • Newbie
  • *
  • Posts: 4
    • View Profile
See, the subject line. There seem to be many differences between Excel and Paramquery, to the extent that work-arounds are not even possible. We need to distinguish between 'empty cell' and 'cell with 0'. It seems that JavaScript falsy values are used instead of Excel interpretations.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6263
    • View Profile
=B8<>0 can be used to distinguish between 'empty cell' and 'cell with 0', it can be verified here: https://paramquery.com/pro/demos/import-xlsx