how do I stop this appearing.......#DIV/0!

[Scudo]

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

 

[Peo Sjoblom]

=IF(A2="","",A1/A2)

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Anne Troy]

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

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Scudo]

I should have put my formula in sorry.

=N5/B5 this is in cell L5 and #div/0! appears in L5 if N5 or B5 are blank.

 

[CLR]

Use this in L5..........

=IF(OR(N5=0,B5=0),"",N5/B5)

Vaya con Dios,
Chuck, CABGx3

 

[Scudo]

That sorted it , Chuck

thanks

Use this in L5..........

=IF(OR(N5=0,B5=0),"",N5/B5)

Vaya con Dios,
Chuck, CABGx3