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