Filtering
Posted by Bruce Childers on August 11, 2000 4:07 PM
I have a link from a worksheet to pull values from a column.
The result puts zeros where the source cell was blank.
How do I filter the link or ? to leave cells blank?
Posted by Celia on August 11, 0100 7:19 PM
Bruce
=IF(A1="","",A1)
For an explanation of the formula, look up IF_WorksheetFunction in the Help file.
Celia
