Query Returning an "N/A"

How can I incorporate in my query to make the cell(s) show as blank if the query result is “N/A”.

Hi @dbashamjr,
You can add IFNA(QUERY(your query),IFERROR(1/0)).
If the query returns N/A, it will display blank. IFERROR(1/0) displays as blank.

More about IFNA() here:

Does this help?


That appears to have done it. Thanks very much for the assist.

1 Like