Query Returning an "N/A"

Google Sheets
1

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

2

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:
https://support.google.com/docs/answer/9365944?hl=en

Does this help?

Jon

3

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

1 Like