Using an IF statement along with a filter statement

Question

I am trying to add an IF statement to the below filter. The Filter is pulling data from a different sheet based off account data.

I am trying to add an IF that will replace the "0" and "blanks" with "NULL" Reason being I have another filter that pulls data based off what is outputted in each column C,D & E at a specific count of 20 rows. attached is a screenshot of the field. Any help would be appreciated. Thank you in advance.

=FILTER(Accounts!A2:C47, Accounts!G2:G47=A1, "No Match")

I've tried multiple different IF configurations. If I put it before the filter it can't pull the filter data. Any attempt at putting it within has proven unsuccessful.