Adding Text to Calculated Field
This is the calcualtion in my cell H4:
=IF(Availability!$E$2<=0,"Not Available","Available")
What I would like to see is if it is possible to add the date to the field
so that it looks like "3/2: Available". Is that possible, or do I have to do
this:
=IF(Availability!$E$2<=0,"3/2: Not Available","3/2: Available") for each cell?
Thanks
|