Cell is not blank

  • Thread starter Thread starter David P.
  • Start date Start date
D

David P.

How do you do that in an if statement? If cell is not blank. Thank you.
 
=if(a1="","it's blank","it's not blank")
or
=if(a1<>"","it's not blank","it's blank")

(Excellent name!)
 
Hi,

Another way to test is

=IF(ISBLANK(A1),true,false)

another way

=IF(COUNTBLANK(A1),"blank","notblank")

technically you could also use

=IF(COUNTA(A1),"notblank","blank")
 
If the cell is *empty* (which can be considered to be different than blank),
then all 3 of those of those formulas return what you'd expect. However, if
the cell contains a formula blank ("") then the results are different in 2
out of 3 of the formulas.

You can reduce this:

=IF(ISBLANK(A1),TRUE,FALSE)

To:

=ISBLANK(A1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If blank do nothing 2
How To Have A Cell Be Blank If... 2
Blank Cell Reference, without if statement 4
If blank statement 4
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Excel Concatenate with line breaks but ignore blank cells 3
Custom Number Format for text 8

Back
Top