Display "0" instead of #NUM!

[KINNEY0201]

I need to add another condition to a formula and can't seem to get it to work correctly.

Could someone please tell me the correct way to add:

If #NUM! shows up to display "0"

to

=MEDIAN(IF((Z:Z=AT17)*(Y:Y="TRANS")*(AD:AD<>"LEAP"),AE:AE))


Thank you very much!