Number of posts : 1 Location : Bentonville, AR Company : Tyson Foods, Inc. Title : Category Analyst Registration date : 2013-06-04
Subject: Return a zero when reference cell is blank Tue Sep 01, 2015 4:01 pm
=IF(ISBLANK(A3),"",A3) Neat little formula I used today. I specifically needed it when referencing cells in my performance data sheet. The performance library would error out when it had nothing to reference.
Subject: Return a zero when reference cell is blank 
Tue Sep 01, 2015 4:01 pm