MrExcel Publishing
Your One Stop for Excel Tips & Solutions

global changes

Posted by Andrew miller on September 25, 2001 9:10 AM

I have a workbook that contains multiple sheets. The cells in some sheets refer back to other sheets within this workbook for their values. If the cell that another cells refers too is blank, then the cell that is looking to the other automatically fill itself in with a zero. I don't want cells to fill in with a zero. Is there anyway I can make the workbook so that if one cell is blank, the other cells that look to it also will be blank instead of zero? Thank you for your time.

Posted by dan on September 25, 2001 9:22 AM

I am guessing there is an if involved, but in anycase this will do..


"" would mean empty in both cases, if empty return empty.