NWA Intactix Users Group

For users of Intactix software in the NW Arkansas region and beyond
 
HomeCalendarGalleryFAQSearchRegisterMemberlistUsergroupsLog in

Share | 
 

 Return a zero when reference cell is blank

View previous topic View next topic Go down 
AuthorMessage
MHawkins



Number of posts : 1
Location : Bentonville, AR
Company : Tyson Foods, Inc.
Title : Category Analyst
Registration date : 2013-06-04

PostSubject: 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.
Back to top Go down
View user profile
 
Return a zero when reference cell is blank
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» Just what should a gradual return to work look like?
» Sudden Return of Migraines
» How to select all in codebox for phpbb2?
» Hundreds Of Syrian Refugees 'Return Home
» How to get total rowcount of a table using Selenium IDE

Permissions in this forum:You cannot reply to topics in this forum
NWA Intactix Users Group :: Tips N Tricks :: MS Excel-
Jump to: