To return a blank result using the IF function, you can use an empty string (""). In the example shown, the formula in D5 (copied down) is:
=IF(B5=1,C5,"")
How this formula works
This formula is based on...

To count total lines in a cell, you can use a formula based on the LEN, SUBSTITUTE, and CHAR functions.
In the example, we are using this formula:
=LEN(B5)-LEN(SUBSTITUTE(B5,CHAR(10),""))+1
How the...

If you want to highlight cells that are blank or empty with conditional formatting, you can do so with a simple formula based on the ISBLANK function. For example, if you want to highlight blank cells in the range B4:...

To take an action only when the cell is not blank (not empty), you can use a formula based on the IF function. In the example shown, column D holds task complete dates. The formula in cell E5 is:
=IF(D5<>"...

To get the first non-blank value (text or number) in a in a one-column range you can use an array formula based on the INDEX, MATCH, and ISBLANK functions. In the example shown, the formula in D10 is:
{=INDEX(B3...

To test a cell and take some action if the cell is blank (empty), you can use the IF function. The formula in cell E5 is:
=IF(D5="","Open","Closed")
How this formula works
The logical...

To show a checkmark when a task is complete, you can use a formula based on the IF and CHAR functions. In the example shown, the formula in D5, copied down, is:
=IF(C5="complete",CHAR(252),"")...

To count the total words in a cell, you can use a formula based on the LEN and SUBSTITUTE functions. In the example shown, C3 contains this formula:
=LEN(TRIM(B3))-LEN(SUBSTITUTE(B3," ",""))+1
How...

To run a formula only when one or more cells are not blank, you can use the IF function with an appropriate logical criteria. In the example shown, the formula in E5 is:
=IF(COUNT(C5:C7)=3,SUM(C5:C7),"")...

To set a check register formula that calculates a running balance, you can use a formula based on simple addition and subtraction.
In the example shown, the formula in G6 is:
=G5-E6+F6
How this formula works
The...

To test multiple cells, and return the value from the first non-blank cell, you can use a formula based on the IF function. In the example shown, column D holds task complete dates. The formula in cell F5 is:
=IF(B5...