test if column isblank

[Guest]

Probbably very basic but just cannot think grateful for any help.

How do i test using a built in formula if a column is blank ie it has no
text or numbers in it. I can do it using code etc but would like to use a
formula

 

[Bob Phillips]

=COUNTA(A:A)=0

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Thank you i knew it was basic!!
--
with kind regards

Spike

=COUNTA(A:A)=0

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

Just be sure to look out for formulae that return "" like

=IF(1=1,"","")
--
Gary's Student

Thank you i knew it was basic!!