How do I hide a formula message?

PHM · Oct 27, 2004

My formula result is #DIV/0!
The cells the formula references has no value.
How can I hide the "#DIV/0! ?

Frank Kabel · Oct 27, 2004

Hi
try something like
=IF(N(A1)=0,"",B1/A1)