>>> "MB" == Michael Brand writes: > Hi Uwe > On Tue, Jun 11, 2019 at 11:36 AM Uwe Brauer 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) Ha, of course, thanks, why did that occur to me? I am bit surprised by the () in Smith, should "Smith" not be sufficient? But it is not indeed, how odd? Anyhow, thanks a lot. Uwe