Re: ISBLANK for a Range

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <SIGE_GOEVAERTS@xxxxxxxxxxx> wrote in message
news:1127832888.930774.161350@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi Dana,
>
> Was exactly where I was looking for!
> Thx Sige
>


.

Relevant Pages