=Cell("contents",A1) returns a 0 if the cell is empty. Need to return nothing
Posted on 2006-11-27
In my spreadsheet in D42, I have =CELL("contents",'Training Worksheet'!D10) but if 'Training Worksheet'!D10 is empty, D42 displays a 0. How can I return nothing?? Extremely urgent and need a fast turn around if possible.
As always, I thank you in advance!