| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Making Blank Cells
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making Blank Cells
Try
=IF(H5<"",H5,"") Mike "Workbook" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making Blank Cells
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Workbook" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making Blank Cells
=IF(H5="","",H5)
-- David Biddulph "Workbook" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making Blank Cells
How does this relate to your earlier post, where you were concerned
with a cell containing either 11 or 12? Pete On Feb 4, 12:56*pm, Workbook wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making a Blank Cell | Charts and Charting in Excel | |||
| Making Cell Blank | Excel Worksheet Functions | |||
| Blank cells in named range- how to ignore them when making my graph? Help plz! | Excel Discussion (Misc queries) | |||
| Making Blank Cells Really Blank (Zen Koan) | Excel Worksheet Functions | |||
| making graphs ignore "blank " cells | Excel Discussion (Misc queries) | |||
Linear Mode
