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.