You can use the IF function in Google Sheets to check whether a cell is not blank. In the IF, you can refer to the cell to test if it’s not blank and then specify a value to return if the condition is TRUE and another value to return if the condition is FALSE.
Formula to Check IF a Cell is Not Blank
You can use the below steps to write this formula:
- First, enter =IF( in a cell.
- In the first argument, refer to the cell we want to test.
- After that, use (<>””) does-not-equal-operator and a blank value using double quotation marks.
- Next, enter the value to get if the condition is true (second argument) and then a value to get if the condition is false.
- In the end, hit enter to get the result.
=IF(C4<>"","Yes","No")When you hit enter, it returns “Yes” in the result. The cell A2 has a value in it, and in the formula, you have specified “Yes” to return if the condition is TRUE.
Other Formula to Test IF a is Not Blank
You can also use a simple condition to test it without using the IF.
- In a cell, enter (=), and then refer to the cell you want to test.
- Enter the does not equal operator and a blank value using double quotation marks.
- Just hit enter after that.
=A4<>""