Cell is not blank
 

How do you do that in an if statement? If cell is not blank. Thank you.
--
David P.

Cell is not blank
 

One way to test it: =IF(A1<"", ...
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"David P." wrote:
How do you do that in an if statement? If cell is not blank. Thank you.

Cell is not blank
 

=if(a1="","it's blank","it's not blank")
or
=if(a1<"","it's not blank","it's blank")

(Excellent name!)

David P. wrote:

How do you do that in an if statement? If cell is not blank. Thank you.
--
David P.

--

Dave Peterson

Cell is not blank
 

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 this helps, please click the Yes button

Cheers,
Shane Devenshire


"David P." wrote:

How do you do that in an if statement? If cell is not blank. Thank you.
--
David P.

Cell is not 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)

--
Biff
Microsoft Excel MVP


"Shane Devenshire" wrote in
message ...
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 this helps, please click the Yes button

Cheers,
Shane Devenshire


"David P." wrote:

How do you do that in an if statement? If cell is not blank. Thank you.
--
David P.