How do I get #DIV/0! to stop appearing when a cell is blank.
This is the formula I am using...
=D15/(POWER(E15,2)/10000)
How do I get #DIV/0! to stop appearing when a cell is blank.
This is the formula I am using...
=D15/(POWER(E15,2)/10000)
=IF(E15=0,"",=D15/(POWER(E15,2)/10000) )
HTH. Best wishes Harald
"S S" <[email protected]> skrev i melding
news:[email protected]...
> How do I get #DIV/0! to stop appearing when a cell is blank.
> This is the formula I am using...
>
> =D15/(POWER(E15,2)/10000)
>
>
Please watch those equal signs!
=IF(E15=0,"",D15/(POWER(E15,2)/10000))
(and spaces, too <vbg>.)
Harald Staff wrote:
>
> =IF(E15=0,"",=D15/(POWER(E15,2)/10000) )
>
> HTH. Best wishes Harald
>
> "S S" <[email protected]> skrev i melding
> news:[email protected]...
> > How do I get #DIV/0! to stop appearing when a cell is blank.
> > This is the formula I am using...
> >
> > =D15/(POWER(E15,2)/10000)
> >
> >
--
Dave Peterson
If you can live with a zero, try:
=(D15>0)*D15/(E15^2/10000)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"S S" <[email protected]> wrote in message
news:[email protected]...
> How do I get #DIV/0! to stop appearing when a cell is blank.
> This is the formula I am using...
>
> =D15/(POWER(E15,2)/10000)
>
>
You sure?
Ragdyer wrote:
>
> If you can live with a zero, try:
>
> =(D15>0)*D15/(E15^2/10000)
>
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "S S" <[email protected]> wrote in message
> news:[email protected]...
> > How do I get #DIV/0! to stop appearing when a cell is blank.
> > This is the formula I am using...
> >
> > =D15/(POWER(E15,2)/10000)
> >
> >
--
Dave Peterson
Oops. =Copy-paste without thinking. Sorry and thanks Dave.
Best wishes Harald
"Dave Peterson" <[email protected]> skrev i melding
news:[email protected]...
> Please watch those equal signs!
>
> =IF(E15=0,"",D15/(POWER(E15,2)/10000))
>
> (and spaces, too <vbg>.)
>
> Harald Staff wrote:
> >
> > =IF(E15=0,"",=D15/(POWER(E15,2)/10000) )
> >
> > HTH. Best wishes Harald
> >
> > "S S" <[email protected]> skrev i melding
> > news:[email protected]...
> > > How do I get #DIV/0! to stop appearing when a cell is blank.
> > > This is the formula I am using...
> > >
> > > =D15/(POWER(E15,2)/10000)
> > >
> > >
>
> --
>
> Dave Peterson
Of course I was sure.
If I wasn't sure, I wouldn't have posted it!
But being *sure* and being *right* are 2 different things.
I was darn sure wrong though ... wasn't I?<bg>
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> You sure?
>
> Ragdyer wrote:
> >
> > If you can live with a zero, try:
> >
> > =(D15>0)*D15/(E15^2/10000)
> >
> > --
> > HTH,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
-
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
-
> > "S S" <[email protected]> wrote in message
> > news:[email protected]...
> > > How do I get #DIV/0! to stop appearing when a cell is blank.
> > > This is the formula I am using...
> > >
> > > =D15/(POWER(E15,2)/10000)
> > >
> > >
>
> --
>
> Dave Peterson
Are you babbling? <gd&r>
Ragdyer wrote:
>
> Of course I was sure.
> If I wasn't sure, I wouldn't have posted it!
>
> But being *sure* and being *right* are 2 different things.
>
> I was darn sure wrong though ... wasn't I?<bg>
> --
> Regards,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > You sure?
> >
> > Ragdyer wrote:
> > >
> > > If you can live with a zero, try:
> > >
> > > =(D15>0)*D15/(E15^2/10000)
> > >
> > > --
> > > HTH,
> > >
> > > RD
> > >
> >
> > --------------------------------------------------------------------------
> -
> > > Please keep all correspondence within the NewsGroup, so all may benefit
> !
> >
> > --------------------------------------------------------------------------
> -
> > > "S S" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > How do I get #DIV/0! to stop appearing when a cell is blank.
> > > > This is the formula I am using...
> > > >
> > > > =D15/(POWER(E15,2)/10000)
> > > >
> > > >
> >
> > --
> >
> > Dave Peterson
--
Dave Peterson
I like to call it rambling.
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Are you babbling? <gd&r>
>
> Ragdyer wrote:
> >
> > Of course I was sure.
> > If I wasn't sure, I wouldn't have posted it!
> >
> > But being *sure* and being *right* are 2 different things.
> >
> > I was darn sure wrong though ... wasn't I?<bg>
> > --
> > Regards,
> >
> > RD
> >
>
> --------------------------------------------------------------------------
-
> > Please keep all correspondence within the NewsGroup, so all may benefit
!
>
> --------------------------------------------------------------------------
-
> >
> > "Dave Peterson" <[email protected]> wrote in message
> > news:[email protected]...
> > > You sure?
> > >
> > > Ragdyer wrote:
> > > >
> > > > If you can live with a zero, try:
> > > >
> > > > =(D15>0)*D15/(E15^2/10000)
> > > >
> > > > --
> > > > HTH,
> > > >
> > > > RD
> > > >
> > >
> >
> --------------------------------------------------------------------------
> > -
> > > > Please keep all correspondence within the NewsGroup, so all may
benefit
> > !
> > >
> >
> --------------------------------------------------------------------------
> > -
> > > > "S S" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > How do I get #DIV/0! to stop appearing when a cell is blank.
> > > > > This is the formula I am using...
> > > > >
> > > > > =D15/(POWER(E15,2)/10000)
> > > > >
> > > > >
> > >
> > > --
> > >
> > > Dave Peterson
>
> --
>
> Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks