View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roadkill roadkill is offline
external usenet poster
 
Posts: 173
Default 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