Pls Help

B

beemerGirL

Hi this is my first time working with formulas from scratch so I need some
assistance.

I just need to create a formula that will provide a message in a different
cell (not in a popup message) if a range of cells (ie: A3:A30) are all
filled, no cells are left blank.

What I'm trying to do is create a self registration for people to sign up
for classes and once all cells are filled with names I want a message to
appear saying "Sorry this Class is filled, Pls contact......")

Thanks!
 
C

Carim

Hi,

=IF(COUNTBLANK(A3:A30)=0,"Sorry","Only "&COUNTBLANK(A3:A30)&" Spot
Left")

should do the job ...

HTH
Cheers
Carim
 
B

beemerGirL

Hi Carim,

Thanks for the reply but I tried that and what it does, I assume is count
the blank spots. I only want the message ("Class is filled") to appear if
there are NOMORE blanks left in the fields (A3:A30). Any suggestions?
 
B

beemerGirL

Carim...

I tried playing around with what you gave me and it worked (disregard my
last post)! Thanks so much! You really helped with what I needed.

Mary Ann
 
Top