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

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

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

Adding Text to Calculated Field
 

Maybe this:

Assuming E2 is a date and "3/2" is that date in month/day format:

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


--
Biff
Microsoft Excel MVP


"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

Adding Text to Calculated Field
 

Oops, yes, the 3/2 is a date. But it is not in any fields presently. E2 on my
Availability sheet is a calculated field itself and is set as a number. So at
this point it is just text.

Now I suppose we could add it to another sheet or group of hidden cells if
need be.

"RoadKill" wrote:

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