View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default Adding Text to Calculated Field

Need more info. Where are your dates? And where are your cells with the
formulas?

Tyro

"RoadKill" wrote in message
...
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