IF function adding a text string after a number in the same argument.

[Zyphon]

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.

My last post got locked due to poor title, I hope this title is a lot more explanatory.

Thanks.

[VBA Noob]

Hi,

Somethime like

=IF(COUNTA(A5:A15)=0,"Full",COUNTA(A5:A15)&"/15")

VBA Noob

[Zyphon]

Hi Thanks for the tip I shall give it a try when I get home.

Thank you.

[Zyphon]

Yes this worked a treat, I replaced the "/15" with " Space/s Left" and it works great thanks.

[VBA Noob]

Glad it helped

VBA Noob