[Dba-office] Excel: sub-set of a page returns zero for blank

John R Bartow jbartow at winhaven.net
Thu May 12 18:45:37 CDT 2016

Hi all,

I'm using Excel column referencing in this manner =IF(Office!B:B ="yes",
Office!J:J, "") to pull together certain columns of a the main "Office"
sheet into another sheet.


Unfortunately, regardless of cell formatting, if the referenced cell is
empty it returns a zero. How can I eliminate the zero?


Much of the referenced information in the subset sheet's column is plain
text data.



John B

More information about the Dba-office mailing list