View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Adding Text to Calculated Field

If it is the current date, then one way:

=TEXT(TODAY(),"m/dd") & ": " & IF(Availability!$E$2<=0,"Not
Available","Available")

HTH,
Paul

--

"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