| 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! |
| 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) | |||
Threaded Mode
