Excel Magic Trick 1155

IF Function: Checking For Empty Cells (5 Methods)

DESCRIPTION

IF Function: Checking For Empty Cell & Zero Length Text Strings:
(00:08) Problem Setup
(00:56) IF function logical test using Zero Length Text String (checks for empty cell or zero length text string)
(01:40) IF function logical test using ISBLANK function (checks for empty cell)
(03:10) IF function logical test using ISNUMBER function (checks for number)
(04:04) IF function logical test using OR function to check two cells using Zero Length Text String (checks for empty cell or zero length text string)
(05:00) IF function logical test using COUNT function to check two cells to see if they are numbers (COUNT counts numbers ONLY)

Formula for Number of Days between two dates, How to avoid the empty cells
Check for empty cells, Check for Blanks. Check for Zero Length Text String