ISBLANK with AND Formula Returning Value Error

[ScottTemple]

Hello,

I have the following formula in cell O2:

=IF(AND(ISBLANK(I2),ISBLANK(H2)),"",((+H2)/(I2^2*3.1415929/4*0.16*12)))

However, when I have a value in H2 and no value in I2 I get a #DIV/0! error, but if I have a value in I2 and no value in H2, I get zero. Any suggestions?

 

[Joe4]

It is quite simply replacing:

ISBLANK(H2)

in your formula with:

H2=""

So it would look like this:

=IF(OR(ISBLANK(I2),H2=""),"",((+H2)/(I2^2*3.1415929/4*0.16*12)))

 

[ScottTemple]

Sweet, thanks Joe!

 

[ScottTemple]

Do you happen to know how that works with a Spill Array? I'm using that setup in a different workbook and I have this for my formula:

=IF(OR(ISBLANK(INDEX(A2#,,5),(INDEX(A2#,,6)="","",IF(T2#,(((INDEX(A2#,,6)*4)/3.14)/(T2#*(INDEX(A2#,,5)^2)))/12)))

 

[Joe4]

Sweet, thanks Joe!

You are welcome.

Do you happen to know how that works with a Spill Array? I'm using that setup in a different workbook and I have this for my formula:

=IF(OR(ISBLANK(INDEX(A2#,,5),(INDEX(A2#,,6)="","",IF(T2#,(((INDEX(A2#,,6)*4)/3.14)/(T2#*(INDEX(A2#,,5)^2)))/12)))

That is really a different question that would warrant its own thread.
(I don't know that I would be able to help you with that question, anyhow).

 

[ScottTemple]

No worries, thanks for all your help Joe.