Get formula to return Blank instead of Zero
Posted by chezlinds on January 29, 2002 9:16 AM
I have a workbook with several worksheets. I am using one of the sheets as a master to populate the others. My problem is that some of the cells in the master don't have any contents, but when I use the formula such as
=(MASTER!A1) to populate corresponding cells on other sheets if there's no value it comes up as 0 or (if the cell is formatted as a date) 1/0/00. Any help appreciated.