If I want to divide 2 cells to get an average and there is no # in cell yet
the cell where the fomula reads $DIV/0! I would like that cell to be blank.
how do I write the formula.

my formula reads =(J5/L5) my answer in that cell reads $DIV/0! since i do
not have any data yet

thanks

--
Message posted via http://www.officekb.com