From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: Basic question re. spreadsheet function
Date: Thu, 9 Jan 2014 16:36:08 +0100
Message-ID: <CALn3zog9U0_EhQ04hcW5e2cMw1ufAm_Wk7ko2OZGSwUxbqcPaQ@mail.gmail.com>
References: <CAEvO2fcAStuAnvU0Xs2k--uzK+jLhHh+x2qkxuQwRwRTVUYX5g@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:36006)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1W1HeU-0002Mu-Op
	for emacs-orgmode@gnu.org; Thu, 09 Jan 2014 10:36:14 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1W1HeT-0003fj-J2
	for emacs-orgmode@gnu.org; Thu, 09 Jan 2014 10:36:10 -0500
Received: from mail-lb0-x22d.google.com ([2a00:1450:4010:c04::22d]:62415)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1W1HeT-0003fb-BZ
	for emacs-orgmode@gnu.org; Thu, 09 Jan 2014 10:36:09 -0500
Received: by mail-lb0-f173.google.com with SMTP id y6so557817lbh.18
	for <emacs-orgmode@gnu.org>; Thu, 09 Jan 2014 07:36:08 -0800 (PST)
In-Reply-To: <CAEvO2fcAStuAnvU0Xs2k--uzK+jLhHh+x2qkxuQwRwRTVUYX5g@mail.gmail.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Steve Dowe <stephen.dowe@gmail.com>
Cc: Org Mode <emacs-orgmode@gnu.org>

Hi Steve

On Thu, Jan 9, 2014 at 11:13 AM, Steve Dowe <stephen.dowe@gmail.com> wrote:
> $12 = if($9=quoted,$6,0)

Follow this path: http://orgmode.org/worg > Tutorials > Tutorials on
specific features > Tables, Spreadsheet, Plotting > The following are
[...] > most of the automated Emacs Regression Tests (ERT) for Org
tables

There you will find test-org-table/compare and there if("$1" == "(z)",
x, y) which hopefully answers your question. The additional
parentheses are Org specific, not Calc specific.

Michael