Cell display
=IF(Linked_Cell="","",Linked_Cell)
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------
"Nuts" wrote in message
...
I created a workbook that has a summary page with cells that link to cells
in
other pages of the workbook. These cells are in date format. When there
is
no entry in the cells of the other pages, the summary page cell shows
1/01/1900. I would like the cell on the summary page to be blank if the
linked cell is blank. Does anyone know how to do this?
--
Thanks
|