MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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