CODEWITHSUNDEEP
excel
Ahdee
Ahdee

Reputation: 4949

Test if adjacent cells is blank from a formula

A1 = if(A2<0, "A2", "")

The cell A1 will either contain data from cell A2or be blank. I wanted to know how to test in B1 if A1 is blank or not. I tried istext(A1) or not(isblank(A1)) but both result in True because it is reading the formula and not what the condition of A1 produces. How would I go about solving this? Thanks!

Upvotes: 1

Views: 1269

Answers (1)

jmstoker
jmstoker

Reputation: 3475

To test if a cell is not blank use <> and "".

IF( A1 <> "", "Not Blank", "Is Blank" )

Upvotes: 3

Related Questions