From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: Row formula in orgtbl mode
Date: Wed, 4 May 2011 15:55:58 +0200
Message-ID: <BANLkTinAQ6rUsN5cxM_njYTCcA_ZY7HLRg@mail.gmail.com>
References: <BANLkTine6axsa4JiM9vV8GUjiXW7CQqTaw@mail.gmail.com>
	<4dc153e9.4d05df0a.391e.25e4@mx.google.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:60389)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1QHcYb-0004Ks-Tq
	for emacs-orgmode@gnu.org; Wed, 04 May 2011 09:56:02 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1QHcYa-0003Aw-Pi
	for emacs-orgmode@gnu.org; Wed, 04 May 2011 09:56:01 -0400
Received: from mail-ey0-f169.google.com ([209.85.215.169]:39517)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1QHcYa-0003Ap-LA
	for emacs-orgmode@gnu.org; Wed, 04 May 2011 09:56:00 -0400
Received: by eyd9 with SMTP id 9so391925eyd.0
	for <emacs-orgmode@gnu.org>; Wed, 04 May 2011 06:55:59 -0700 (PDT)
In-Reply-To: <4dc153e9.4d05df0a.391e.25e4@mx.google.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: </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: Michael Bach <phaebz@gmail.com>
Cc: emacs-orgmode@gnu.org

Hi Michael

On Wed, May 4, 2011 at 15:25, Michael Bach <phaebz@gmail.com> wrote:
> | =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 =A0a | =A0 =A0b | =A0 =A0c | =A0 =A0d=
 |
> | Specific cost | =A0 =A01 | =A0 =A09 | =A0 =A02 | =A0 =A03 |
> | System size =A0 | 1000 | 1000 | 1000 | 1000 |
> | =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 =A0 =A0| =A0 =A0 =A0| =A0 =A0 =A0| =
=A0 =A0 =A0|
> | ... =A0 =A0 =A0 =A0 =A0 | =A0... | =A0... | =A0... | =A0... |
> #+TBLFM: @4=3D@2*@3

Row formulas are not supported, but the new range formulas you already
tried are even more powerful:

> I am wondering how I would need to format the #+TBLFM: line to multiply
> the respective numeric values of rows 2 and 3 in row 4. =A0I am using org
> v.7.4. =A0All my attempts, also trying to define ranges like
> @4$2..@4$5=3D@-1*@-2, fail.

Your range formula @4$2..@4$5=3D@-1*@-2 will work if you upgrade at
least to this commitdiff
http://orgmode.org/w/?p=3Dorg-mode.git;a=3Dcommitdiff;h=3D8237c9ae6d587a226=
46333e0315683675e2db538
and will deliver

|               |    a |    b |    c |    d |
| Specific cost |    1 |    9 |    2 |    3 |
| System size   | 1000 | 1000 | 1000 | 1000 |
|               | 1000 | 9000 | 2000 | 3000 |
| ...           |  ... |  ... |  ... |  ... |
#+TBLFM: @4$2..@4$5=3D@-1*@-2

For this application I would suggest
#+TBLFM: @4$<<..@4$>=3D@-1*@-2

Michael