| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF / ISBLANK | Excel Discussion (Misc queries) | |||
| Isblank | New Users to Excel | |||
| IsBlank | Excel Discussion (Misc queries) | |||
| Error with ISBLANK function | Excel Discussion (Misc queries) | |||
| error message ISBLANK | Excel Discussion (Misc queries) | |||
Hybrid Mode
