Just for interest, using your example and Dana's solution:

=IF(COUNTA(A1:A7)=0,"Blank","Not Blank")+N("Your comment here")

returns #Value. perhaps if you used an example that represented what you
were trying to achieve, it would have been easier to provide an answer to
suit.

--
Regards,
Tom Ogilvy

"Sige" wrote in message
oups.com...
Hi Dana,

Was exactly where I was looking for!
Thx Sige