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 -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
