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

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

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

--
Regards,

Peo Sjoblom

(No private emails please)


"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

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

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.


"Anne Troy" wrote in message
news:47f8b$42c724a4$97c5108d$11649@allthenewsgroup s.com...
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

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

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

Vaya con Dios,
Chuck, CABGx3


"Scudo" wrote in message
.. .
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.


"Anne Troy" wrote in message
news:47f8b$42c724a4$97c5108d$11649@allthenewsgroup s.com...
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

That sorted it , Chuck

thanks


"CLR" wrote in message
...
Use this in L5..........

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

Vaya con Dios,
Chuck, CABGx3


"Scudo" wrote in message
.. .
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.


"Anne Troy" wrote in message
news:47f8b$42c724a4$97c5108d$11649@allthenewsgroup s.com...
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