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.

Related Posts