Try this, Scudo: =IF(ISERROR(A1),"",MYFORMULA)
Or: =IF(ISBLANK(A1),"",MYFORMULA)
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Scudo" wrote in message
k...
This appears in a cell when no information is in the `other` cells that it
calulates from #div/0! is there a way so that if no info in the cells
then
the cell with the formula remains (or appears) blank.

thanks