[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] table, calc, reorder and protect calculation in one cell
|
From: |
Michael Brand |
|
Subject: |
Re: [O] table, calc, reorder and protect calculation in one cell |
|
Date: |
Mon, 17 Jun 2019 08:07:40 +0200 |
Hi Uwe
On Tue, Jun 11, 2019 at 11:36 AM Uwe Brauer <address@hidden> wrote:
> Is this behavior possible? When I delete a row or a column, the TBLFM
> is updated, could that be done for reordering?
You may want to use something like this, (I knew the syntax for ~"$1"~
and used the formula debugger ~C-c {~ to find the syntax for
~"(Smith)"~):
| name | C1 | C2 | Res |
|--------+----+----+-----|
| Smith | 9 | 1 | 1.7 |
| Miller | 6 | 2 | 8 |
| Adams | 5 | 5 | 10 |
#+TBLFM: $4 = if("$1" == "(Smith)", 0.1 * $2 + 0.8 * $3, $3 + $2)
Michael