Can I create an IF function to detect whether a cell is 'populated'.
ie =if(a2="populated with any value",1,0)
Can I create an IF function to detect whether a cell is 'populated'.
ie =if(a2="populated with any value",1,0)
=IF(A1<>"",ValueIfPopulated,ValueIfBlank)
Or
=IF(LEN(A1)=0,ValueIfBlank,ValueIfPopulated)
Last edited by darkyam; 03-14-2008 at 12:44 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks