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

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
Back to top 
Page 1 of 1
 Similar topics
-
» Just what should a gradual return to work look like?
» Sudden Return of Migraines
» Using Xpath how do i locate the correct cell from a table
» 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: