Hi Michael On Wed, May 4, 2011 at 15:35, Michael Bach <pha...@gmail.com> wrote: > # I sent this one previously by mistake in reply to a totally unrelated post, > so now > # again. # and also the answer again for the mail archives with this thread separate
> | | a | b | c | d | > | Specific cost | 1 | 9 | 2 | 3 | > | System size | 1000 | 1000 | 1000 | 1000 | > | | | | | | > | ... | ... | ... | ... | ... | > #+TBLFM: @4=@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. I am using org > v.7.4. All my attempts, also trying to define ranges like > @4$2..@4$5=@-1*@-2, fail. Your range formula @4$2..@4$5=@-1*@-2 will work if you upgrade at least to this commitdiff http://orgmode.org/w/?p=org-mode.git;a=commitdiff;h=8237c9ae6d587a22646333e0315683675e2db538 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=@-1*@-2 For this application I would suggest #+TBLFM: @4$<<..@4$>=@-1*@-2 Michael
