S
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)
This is the formula I am using...
=D15/(POWER(E15,2)/10000)
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
Harald Staff
=IF(E15=0,"",=D15/(POWER(E15,2)/10000) )
HTH. Best wishes Harald
HTH. Best wishes Harald
D
Dave Peterson
Please watch those equal signs!
=IF(E15=0,"",D15/(POWER(E15,2)/10000))
(and spaces, too <vbg>.)
=IF(E15=0,"",D15/(POWER(E15,2)/10000))
(and spaces, too <vbg>.)
R
Ragdyer
If you can live with a zero, try:
=(D15>0)*D15/(E15^2/10000)
=(D15>0)*D15/(E15^2/10000)
D
Dave Peterson
You sure?
If you can live with a zero, try:
=(D15>0)*D15/(E15^2/10000)
H
Harald Staff
Oops. =Copy-paste without thinking. Sorry and thanks Dave.
Best wishes Harald
Best wishes Harald
R
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>
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>
D
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>
R
Ragdyer
I like to call it rambling.