Thread: Isblank error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
puiuluipui puiuluipui is offline
external usenet poster
 
Posts: 468
Default 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!