Isblank error

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!
 
M

Mike H

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.
 
M

Mike H

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.
 
P

puiuluipui

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top