Mindie

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I know the no of different cell formats in a Excel workbo.	Sunil	Excel Discussion (Misc queries)	1	January 31st 05 05:23 PM
numeric cell formats	David McColloch	Excel Discussion (Misc queries)	1	January 8th 05 11:15 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
Too Many Different Cell Formats	Nanette	Excel Worksheet Functions	7	November 15th 04 08:53 PM
Too Many Different Cell Formats	Nanette	Excel Worksheet Functions	1	November 12th 04 04:55 AM

All times are GMT +1. The time now is 08:27 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us