| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Using two different formats for one cell.
I am trying to display a cell in a certain format depending on what cell it
is equal to. For example, =IF(B7=TRUE,C6,E6). If the answer is C6 I want the field to display Jan 22 2004, if it is equal to E6 I want the field to display Jan 2004. The answer would appear in cell K6 for example. |
|
#2
|
|||
|
|||
|
one way:
=IF(B7, TEXT(C6,"mmm dd yyyy"), TEXT(E6,"mmm yyyy")) Note that the result will be text, not actual dates. In article , Mindie wrote: I am trying to display a cell in a certain format depending on what cell it is equal to. For example, =IF(B7=TRUE,C6,E6). If the answer is C6 I want the field to display Jan 22 2004, if it is equal to E6 I want the field to display Jan 2004. The answer would appear in cell K6 for example. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I know the no of different cell formats in a Excel workbo. | Excel Discussion (Misc queries) | |||
| numeric cell formats | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Too Many Different Cell Formats | Excel Worksheet Functions | |||
| Too Many Different Cell Formats | Excel Worksheet Functions | |||
Linear Mode
