How do I hide a formula message?

Guest · 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)

Formula	2	Apr 28, 2009
Supress DIV/0	2	Oct 8, 2013
Averaging a column that contains text	4	May 28, 2010
HELP please... easy function	2	Dec 5, 2009
How to not get '0' or '#DIV/0!' in a cell with a percentage formul	5	Jun 30, 2009
Conditional format for #DIV/0	2	Oct 30, 2009
Taking Average ignoring #DIV/0! in the range...	1	Apr 16, 2009
Average formula	4	Sep 17, 2008

Ask a Question