How do I use IF(ISBLANK() when the cell contains a formula

[slam]

I'm using this formula in cell AG

=IF(ISBLANK(F3),"",SUM(E3:F3))

Though F3 is currently blank, it contains a formula, so its not displaying a blank like I want it to.

How do I resolve this?

 

[VoG]

Try

=IF(F3="","",SUM(E3:F3))

 

[slam]

Excellent, thanks!

 

[T. Valko]

I'm using this formula in cell AG

=IF(ISBLANK(F3),"",SUM(E3:F3))

Though F3 is currently blank, it contains a formula, so its not displaying a blank like I want it to.

How do I resolve this?

VoG's suggestion will do what you want.

Just a "FYI" comment...

The ISBLANK function is POORLY named for what it does. It should be named ISEMPTY.

 

[jmendoza]

Follow up question, i'm trying to use a similar formula for three side by side cells (A1,B1 & C1), my formula in cell D1 is: =if(A1=0&B1=0,"",C1/B1) and I'm getting a '#DIV/0!' result. I know it's because you can't divide by '0', but shouldn't it give me "" instead of this result because A1 & B1 are both equal to zero? Am I missing a step? I tried using 'or' instead of '&', but no luck. I've done this before, but I can't seem to recall how. Thanks in advance.

 

[jmendoza]

Nevermind, I figured it out!!! Thanks!