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).
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.
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
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.
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.