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