Hi,
I wanted to know if there is a way to do the following.
Say you wanted to take bookings for a venue and you had say 15 spaces for that venue.
I could use a simple method to count all the names such as the COUNTA() function.
Say the COUNTA was in CELL A2 and in CELL A3 I had 15-A2 which is my maximum for any one booking.
I know I could use the IF command to say IF (A3=0,"FULL",???")
The problem is;is there a way if the value is not 0 to have say 'X' Spaces Left. X being the number of spaces left? Or would I need to just make another IF command is an adjacent cell?
Thanks in advance for any help given.![]()
Bookmarks