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!

Hi,

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

should do the job ...

HTH
Cheers
Carim

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?

"Carim" wrote:

Hi,

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

should do the job ...

HTH
Cheers
Carim

Try this:

=IF(COUNTA(A3:A30)=28,"Class is filled")

HTH,
Paul

"beemerGirL" <beemerGirL @discussions.microsoft.com wrote in message
...
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!

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

"Carim" wrote:

Hi,

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

should do the job ...

HTH
Cheers
Carim

Mary Ann,

Glad I could help ...

Thanks for the feedback

Cheers
Carim