Just one warning.

This will hide any error that is produced, not just the #DIV/0! error.

I think you would be better off with Ron's suggested formula.


Gord Dibben MS Excel MVP

On Fri, 4 May 2007 20:09:00 -0700, Dreamstar_1961
wrote:

found the answer, =iferror(a1/b1,"")

"Dreamstar_1961" wrote:

is there a way to stop the devide by 0 or empty cell error from showing if
the cell you are using is empty?