[SOLVED] 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" <me@nospam.fictional> wrote in message
news:JoFxe.63521$Vo6.8237@fe3.news.blueyonder.co.uk...
> 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" <me@nospam.fictional> wrote in message
news:JoFxe.63521$Vo6.8237@fe3.news.blueyonder.co.uk...
> 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" <ng@officearticles.com> wrote in message
news:47f8b$42c724a4$97c5108d$11649@allthenewsgroups.com...
> Try this, Scudo: =IF(ISERROR(A1),"",MYFORMULA)
> Or: =IF(ISBLANK(A1),"",MYFORMULA)
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>
>
> "Scudo" <me@nospam.fictional> wrote in message
> news:JoFxe.63521$Vo6.8237@fe3.news.blueyonder.co.uk...
> > 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" <me@nospam.fictional> wrote in message
news:mOFxe.381$vF2.217@fe1.news.blueyonder.co.uk...
> 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" <ng@officearticles.com> wrote in message
> news:47f8b$42c724a4$97c5108d$11649@allthenewsgroups.com...
> > Try this, Scudo: =IF(ISERROR(A1),"",MYFORMULA)
> > Or: =IF(ISBLANK(A1),"",MYFORMULA)
> > *******************
> > ~Anne Troy
> >
> > www.OfficeArticles.com
> > www.MyExpertsOnline.com
> >
> >
> > "Scudo" <me@nospam.fictional> wrote in message
> > news:JoFxe.63521$Vo6.8237@fe3.news.blueyonder.co.uk...
> > > 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" <croberts@tampabay.rr.com> wrote in message
news:eVksUI2fFHA.1948@TK2MSFTNGP12.phx.gbl...
> Use this in L5..........
>
> =IF(OR(N5=0,B5=0),"",N5/B5)
>
> Vaya con Dios,
> Chuck, CABGx3
>
>
> "Scudo" <me@nospam.fictional> wrote in message
> news:mOFxe.381$vF2.217@fe1.news.blueyonder.co.uk...
> > 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" <ng@officearticles.com> wrote in message
> > news:47f8b$42c724a4$97c5108d$11649@allthenewsgroups.com...
> > > Try this, Scudo: =IF(ISERROR(A1),"",MYFORMULA)
> > > Or: =IF(ISBLANK(A1),"",MYFORMULA)
> > > *******************
> > > ~Anne Troy
> > >
> > > www.OfficeArticles.com
> > > www.MyExpertsOnline.com
> > >
> > >
> > > "Scudo" <me@nospam.fictional> wrote in message
> > > news:JoFxe.63521$Vo6.8237@fe3.news.blueyonder.co.uk...
> > > > 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
> > > >
> > > >
> > >
> > >
> >
> >
>
>