Filter Formula Don't display #CALC!

Hello,

With a Filter formula, is there a way to have is show a blank cell or have the words "No Data" be displayed instead of #CALC! when no information is returned?

Here is an example of a formula I am using:

=IF(B2="","",FILTER(INDEX(TData,SEQUENCE(ROWS(TData)),{1,2,3,4,5,6,7,8,9,10,11}),IF(B2="All",1,TData[EMPLOYEE NAME]=B2)*(TData[AUDIT DATE]>=J4)*(TData[AUDIT DATE]<=K4)*IF(K3="All",1,TData[SHIFT]=K3)*IF(K5="All",1,TData[LOCATION]=K5)*IF(K6="All",1,TData[POINT ASSESSMENT]=K6) *IF(K7="All",1,TData[COACHING]=K7) *IF(K8="All",1,TData[CAUSE]=K8)))

I appreciate any help,

Thank you,
Nick

Another option

Formula:

=IF(B2="","",FILTER(INDEX(TData,SEQUENCE(ROWS(TData)),{1,2,3,4,5,6,7,8,9,10,11}),IF(B2="All",1,TData[EMPLOYEE NAME]=B2)*(TData[AUDIT DATE]>=J4)*(TData[AUDIT DATE]<=K4)*IF(K3="All",1,TData[SHIFT]=K3)*IF(K5="All",1,TData[LOCATION]=K5)*IF(K6="All",1,TData[POINT ASSESSMENT]=K6) *IF(K7="All",1,TData[COACHING]=K7) *IF(K8="All",1,TData[CAUSE]=K8),"No Data"))

Thank you for your help!

Glad to help & thanks for the feedback.