- To: "Howard Lowndes" <lannet@xxxxxxxxxxxxx>, slug@xxxxxxxxxxx
- Subject: Re: [SLUG] Open Office conditional format question
- From: "Gary Bennett" <beancounterz@xxxxxxxxx>
- Date: Wed, 2 Jul 2008 14:41:41 +1000
- Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=8RQHUcc+HUaBtndJV77VZp/nmrG8KdmdsBcLbUmmFx0=; b=cXk6B1IY3raMlonDmjMLVh6dV91Xmi0RDk9v6CtX1i4mBLyKo0K8BVlmICvAbeV3UP B9wZ69R6x927aP5VMV8UJnVdXlQUp1taPbfMOlY/lTuN8mpPXG1zlef5pQHSiCrZ2JES OYDKJBiMMjLjeJHinsiRexRUwgqxq52JbD+j4=
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=pZbrwF7F+FuBu0mGPW3sXZDGGSJioOMjbBGSmEkOY8fl0kNa9P+wbNUGzCqxIX/Hhz qgyY7ss1ECxpprPyIWMuuI9xoH1+fq+ifP4lhoVd7q8G7smcPuK8osqWPm7dDH72wEBv fUGFPBBCFkxF4S+dr3Zc5SvesemaeB/sgf/BE=
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 Mailing List Archives