From mboxrd@z Thu Jan 1 00:00:00 1970 From: Steve Dowe Subject: Basic question re. spreadsheet function Date: Thu, 9 Jan 2014 10:13:07 +0000 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=001a11c339e6546b0a04ef86dcc2 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:60720) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1W1CcE-0007ig-9Q for emacs-orgmode@gnu.org; Thu, 09 Jan 2014 05:13:31 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1W1CcC-0000Te-Ro for emacs-orgmode@gnu.org; Thu, 09 Jan 2014 05:13:30 -0500 Received: from mail-ob0-x22e.google.com ([2607:f8b0:4003:c01::22e]:42505) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1W1CcC-0000Sh-NZ for emacs-orgmode@gnu.org; Thu, 09 Jan 2014 05:13:28 -0500 Received: by mail-ob0-f174.google.com with SMTP id va2so1066164obc.33 for ; Thu, 09 Jan 2014 02:13:28 -0800 (PST) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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: emacs-orgmode@gnu.org --001a11c339e6546b0a04ef86dcc2 Content-Type: text/plain; charset=ISO-8859-1 Hi all, I'm testing out whether I can use a table in org as a project status tracker. In col 6, I have the value of the project (e.g. 162.50) and in col 9, the status (e.g. quoted, approved, invoiced, closed, etc.) I would like to see, at a glance, what the value of quoted work is, so I'm currently doing this in col 12 (pasted from formula editor): # Column Formulas $12 = if($9=quoted,$6,0) ( Col 9 in this instance contains "closed" and Col 6 contains 162.50. ) This formula results in the text closed = quoted ? 162.5 : 0 being displayed in col 12. However, in another row where the col 9 does have the text "quoted", I get pretty much the result I'm looking for, e.g. "400." will appear in col 12 where I have 400.00 in col 6. In the instance where the if test proves false, I would like a zero or nothing appearing. The intention is to sum this column in a footer row. I have consulted http://orgmode.org/manual/Formula-syntax-for-Calc.html#Formula-syntax-for-Calcbut it contains a dead link ( http://orgmode.org/calc/Logical-Operations.html#Logical-Operations) - making it harder to RTFM :-) Thanks, -- Steve --001a11c339e6546b0a04ef86dcc2 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Hi all,

I'm = testing out whether I can use a table in org as a project status tracker.= =A0 In col 6, I have the value of the project (e.g. 162.50) and in col 9, t= he status (e.g. quoted, approved, invoiced, closed, etc.)

I would like to see, at a glance, what the value of quoted w= ork is, so I'm currently doing this in col 12 (pasted from formula edit= or):

# Column Formulas
$12 =3D if($9=3Dquoted,$6,0)

( Col 9 in this instance contains "closed" and Col= 6 contains 162.50. )

This formula results in = the text

=A0closed =3D quoted ? 162.5 : 0

being di= splayed in col 12.=A0 However, in another row where the col 9 does have the= text "quoted", I get pretty much the result I'm looking for,= e.g. "400." will appear in col 12 where I have 400.00 in col 6.= =A0

In the instance where the if test proves false, I would like a zero or = nothing appearing.=A0 The intention is to sum this column in a footer row.<= br>

I have consulted http://orgmo= de.org/manual/Formula-syntax-for-Calc.html#Formula-syntax-for-Calc but = it contains a dead link (http://orgmode.org/calc/Logical-Operations.htm= l#Logical-Operations) - making it harder to RTFM :-)

Thanks,
--
=A0 Steve
--001a11c339e6546b0a04ef86dcc2--