Isblank error
 

Hi, i have this formula in J5:
=IF(ISBLANK(I5);"";F5-(G5+H5+I5))

In I5 i have a formula that doesn't display anything if a certain criteria
is met.
If I5 is blank, i need J5 to be blank too.
But i receive this error :#VALUE!

How can i modify the formula in J5 so the result to be an empty cell?
Can this be done?
Thanks!

Isblank error
 

Hi,

If I5 contains a formula then it isn't blank even if it's returning a null
string. Here's an alternative

=IF(LEN(I5)=0,"",F5-(G5+H5+I5))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"puiuluipui" wrote:

Hi, i have this formula in J5:
=IF(ISBLANK(I5);"";F5-(G5+H5+I5))

In I5 i have a formula that doesn't display anything if a certain criteria
is met.
If I5 is blank, i need J5 to be blank too.
But i receive this error :#VALUE!

How can i modify the formula in J5 so the result to be an empty cell?
Can this be done?
Thanks!

Isblank error
 

Apologies I changed your ; to , for my version of Excel so change them back
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"puiuluipui" wrote:

Hi, i have this formula in J5:
=IF(ISBLANK(I5);"";F5-(G5+H5+I5))

In I5 i have a formula that doesn't display anything if a certain criteria
is met.
If I5 is blank, i need J5 to be blank too.
But i receive this error :#VALUE!

How can i modify the formula in J5 so the result to be an empty cell?
Can this be done?
Thanks!

Isblank error
 

It's working great!!
Thanks allot!

"Mike H" wrote:

Hi,

If I5 contains a formula then it isn't blank even if it's returning a null
string. Here's an alternative

=IF(LEN(I5)=0,"",F5-(G5+H5+I5))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"puiuluipui" wrote:

Hi, i have this formula in J5:
=IF(ISBLANK(I5);"";F5-(G5+H5+I5))

In I5 i have a formula that doesn't display anything if a certain criteria
is met.
If I5 is blank, i need J5 to be blank too.
But i receive this error :#VALUE!

How can i modify the formula in J5 so the result to be an empty cell?
Can this be done?
Thanks!