Thanks Dave works great!!!!!!

Dave Peterson wrote:
=if(l5=0,"",j5/l5)
or

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.
[quoted text clipped - 7 lines]
--
Message posted via http://www.officekb.com


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