Blog

Displaying Blank or a Zero if an error is encountered

  • Post author:
  • Post published:
  • Reading time:1 min read

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