Put an IFERROR around the formula
=IFERROR( your formula, "")
will put a blank ("") instead of an error