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. 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
