#DIV/0! how to stop this in blank cell

[S S]

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)

 

[Harald Staff]

=IF(E15=0,"",=D15/(POWER(E15,2)/10000) )

HTH. Best wishes Harald

 

[Dave Peterson]

Please watch those equal signs!

=IF(E15=0,"",D15/(POWER(E15,2)/10000))

(and spaces, too <vbg>.)

 

[Ragdyer]

If you can live with a zero, try:

=(D15>0)*D15/(E15^2/10000)

 

[Dave Peterson]

You sure?

If you can live with a zero, try:

=(D15>0)*D15/(E15^2/10000)

 

[Harald Staff]

Oops. =Copy-paste without thinking. Sorry and thanks Dave.

Best wishes Harald

 

[Ragdyer]

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>

 

[Dave Peterson]

Are you babbling? <gd&r>

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>

 

[Ragdyer]

I like to call it rambling.