How to change #DIV/0! result for an entire worksheet ?

Giganews Newsgroups
Subject: How to change #DIV/0! result for an entire worksheet ?
Posted by:  lg
Date: Fri, 26 May 2006

The worksheet I created has many forumlas where the 'divisor' can be zero.
The formulae are long and complicated with nested functions.  So, I don't
want to add the If statement for a zero divisor to each cell that can result
in a DIV/0.
Is there a way that I can for an entire spread sheet at once modify the
result from DIV/0 to blank?

Replies