Hi Uwe
On Tue, Jun 11, 2019 at 11:36 AM Uwe Brauer <o...@mat.ucm.es> 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
