N Harkawat wrote...
>If you are only isolating for an error then this should do
>=if(iserror(d3),"bark","bite")
>However it will show "bark" for all instances of error like #N/A, #Div
....

So why not give the OP specifically what he asked for?

=IF(COUNT(1/(ERROR.TYPE(D3)=3)),"bark","bite")