From mboxrd@z Thu Jan  1 00:00:00 1970
From: RC <recif@yahoo.com>
Subject: Question on spreadsheet formula
Date: Sat, 26 Sep 2009 03:08:11 +0000 (UTC)
Message-ID: <loom.20090926T050330-136@post.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1MrNeO-0001zv-0D
	for emacs-orgmode@gnu.org; Fri, 25 Sep 2009 23:08:44 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1MrNeH-0001zj-Qh
	for emacs-orgmode@gnu.org; Fri, 25 Sep 2009 23:08:42 -0400
Received: from [199.232.76.173] (port=59159 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1MrNeH-0001zg-MJ
	for emacs-orgmode@gnu.org; Fri, 25 Sep 2009 23:08:37 -0400
Received: from lo.gmane.org ([80.91.229.12]:50145)
	by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32)
	(Exim 4.60) (envelope-from <geo-emacs-orgmode@m.gmane.org>)
	id 1MrNeH-0000Xc-1r
	for emacs-orgmode@gnu.org; Fri, 25 Sep 2009 23:08:37 -0400
Received: from list by lo.gmane.org with local (Exim 4.50) id 1MrNeE-0000Vc-Je
	for emacs-orgmode@gnu.org; Sat, 26 Sep 2009 05:08:34 +0200
Received: from c-68-46-234-243.hsd1.fl.comcast.net ([68.46.234.243])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Sat, 26 Sep 2009 05:08:34 +0200
Received: from recif by c-68-46-234-243.hsd1.fl.comcast.net with local (Gmexim
	0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Sat, 26 Sep 2009 05:08:34 +0200
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

Hi,
On applying the column formula on the table shown below:
  |-----+------+------+----------|
  | No. |    P |    E | B        |
  |-----+------+------+----------|
  |     |      |      | 0        |
  |   1 | 5000 | 2000 |          |
  |   2 | 7000 | 1000 |          |
  |   3 | 5000 | 1000 |          |
#+TBLFM: $4=@-1$4+$2-$3

I get:
  |-----+------+------+-----------|
  | No. |    P |    E | B         |
  |-----+------+------+-----------|
  |     |      |      | B         |
  |   1 | 5000 | 2000 | B + 3000  |
  |   2 | 7000 | 1000 | B + 9000  |
  |   3 | 5000 | 1000 | B + 13000 |
#+TBLFM: $4=@-1$4+$2-$3

When what I would like is:
  |-----+------+------+-------|
  | No. |    P |    E | B     |
  |-----+------+------+-------|
  |     |      |      | 0     |
  |   1 | 5000 | 1000 | 3000  |
  |   2 | 5000 | 1000 | 9000  |
  |   3 | 5000 | 1000 | 13000 |
#+TBLFM: $4=@-1$4+$2-$3

Is there a way I can restrict application of the column formula to below the
horizontal line.
Thanks,
RC