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

[Susan Harkins]

A quick test -- when the cell is empty, the IF() statement returns an empty
string, as expected. Can you send the worksheet over to me and let me take a
look at it? 

Susan H. 

-----Original Message-----
From: Dba-office [mailto:dba-office-bounces at databaseadvisors.com] On Behalf
Of John R Bartow
Sent: Thursday, May 12, 2016 7:46 PM
To: 'Off Topic' <dba-ot at databaseadvisors.com>; DBA Office
<dba-office at databaseadvisors.com>; 'Discussion of Hardware and Software
issues' <dba-tech at databaseadvisors.com>
Subject: [Dba-office] Excel: sub-set of a page returns zero for blank
Importance: High

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.

 

Regards,

John B

_______________________________________________
Dba-office mailing list
Dba-office at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-office