Isblank error

  • Thread starter Thread starter puiuluipui
  • Start date Start date
P

puiuluipui

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!
 
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.
 
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.
 
It's working great!!
Thanks allot!

Mike H said:
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.
Click to expand...
 
Back
Top