Archive for January, 2007

Hiding the #DIV/0! Message

January 29th, 2007

If you are working with a formula that may refer to a blank cell or otherwise generate an error message, you can use a combination of the IF-THEN-ELSE and the ISERROR function to handle the #DIV/0! or other error messages that may appear.
The IF-THEN-ELSE has 3 parts: the condition, the TRUE condition, the FALSE condition. […]