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
|