Say my data is in range A6:Z with the headers in row 5. I want to display rows with value in column C that is non-zero or
#N/A. I tried
OR(C6:C <> 0, IFNA(C6:C, true)) and
OR(C6:C <> 0, ISNA(C6:C)) and none of them works.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community