Displaying Blank or a Zero if an error is encountered
To display a blank cell if an error is encountered use
=IFERROR(A1/B1,"")
To display a zero in a cell if an error is encountered use
=IFERROR(A1/B1,0)
The IFERROR function is available in Excel 2007 onwards.