ExcelBanter - Using two different formats for one cell.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Using two different formats for one cell. (https://www.excelbanter.com/excel-discussion-misc-queries/12270-using-two-different-formats-one-cell.html)

Mindie

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.

JE McGimpsey

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.

All times are GMT +1. The time now is 02:49 PM.