Re: [SLUG] Open Office conditional format question

["Gary Bennett" <beancounterz@xxxxxxxxx>]

On 7/2/08, Howard Lowndes <> wrote:
>
>
>  Gary Bennett wrote:
>
> > On 7/2/08, Howard Lowndes <> wrote:
> >
> > > I'm trying to set a date in an OO spreadsheet that is defined
> conditionally,
> > > but I am obviously doing something wrong.
> > >
> > >  Here's what I think the conditional should look like but it results in
> the
> > > value of zero (= 30 Dec 1899) being passed into the cell:
> > >
> > >
> =IF(B1="Q1";1/7/2008;IF(B1="Q2";1/10/2008;IF(B1="Q3";1/1/2009;1/4/2009)))
> > >
> > >  OK, apply the cluestick...
> > >
> > >  --
> > >  Howard.
> > >  LANNet Computing Associates - Your Linux people
> <http://lannetlinux.com>
> > >  When you want a computer system that works, just choose Linux;
> > >  When you want a computer system that works, just, choose Microsoft.
> > >  --
> > >  Flatter government, not fatter government; abolish the Australian
> states.
> > >
> > >  --
> > >  SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/
> > >  Subscription info and FAQs:
> > > http://slug.org.au/faq/mailinglists.html
> > >
> > >
> >
> > Howard,
> >
> > Is your result cell formatted as a date? Your calculation works for me.
> >
>
>  Yes it is, but it is returning the result "30 Dec 99" instead of the
> required "1 Jul 08" when cell B1 has the value "Q1" - in fact, any value.

Howard,

Rather than having your dates in a raw format that OO is interpreting
as a calculation, try them in the format =IF(B1="Q1";DATE(2008;7;1)
... etc

Regards, Gary