Find If A Cell Has Value Below It In Excel

In this post we will see how to find if a cell in excel has value below it and not blank.

In the data example below we have some value in column A and in column B, we want to write a formula which tells us if a cell in column A has a value below it or not (blank).

excel data to find if a cell has value below it in excel




As you can see in the data above, column B has true wherever we have a value below a cell in column A.

We will use an IF formula in excel to determine the availability of a value below a cell in excel.

Enter the formula =IF(A2<>””,TRUE,FALSE) in cell B1.

excel formula to check if a cell has value below it in excel

Breaking down the formula

A2<>”” – This checks if A2 has a value or is blank.

TRUE- If the condition in IF formula is true, it returns TRUE otherwise FALSE

excel formula return false as the cell does not have value below it in excel

As you can see above, for cell A1 our formula returns FALSE as we don’t have any below it, now drag the formula down to get the value for all the data in column A.

excel formula has returned true for all the cells that have value below them




Yu see now that as cell A7 has a value below it ,our formula returns TRUE and rest in all the cases it returns FALSE.

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply