Making Blank Cells

  • Thread starter Thread starter Workbook
  • Start date Start date
W

Workbook

Cell K5 is linked to Cell H5, so that whatever gets entered in Cell H5 it
will appear in Cell K5. However, sometimes H5 does not have any data in it
and when that happens Cell H5 enters data which screws up other formulas. Is
it possible to make K5 blank when H5 is blank?Right now I am linking them by
an equal sign and that is not working. Any thoughts?
 
It seems you are using a formula like: =H5
If H5 is blank this returns a zero value
We can avoid this with =IF(ISBLANK(H5), "", H5)
If that does not work for you, we need to know about the 'other formulas
that get screwed up'.
best wishes
 
How does this relate to your earlier post, where you were concerned
with a cell containing either 11 or 12?

Pete
 
Back
Top