On May 6, 3:38*am, "Darts via OfficeKB.com" <u19990@uwe wrote:
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 viahttp://www.officekb.com

--
Message posted viahttp://www.officekb.com

You can also use:

IF(ISERROR(J5/L5),"",J5/L5)