| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| Pivottable adding calculated field? | Charts and Charting in Excel | |||
| PivotTable:Using a calculated field result in another calculated f | Excel Worksheet Functions | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Threaded Mode
