Hi, You can reference the next row with @+1. If I understand your question correctly, this works:
|---+------+-------+-------+-------+-------+---| | ! | Jahr | Menge | Preis | BIPn | BIPr | W | |---+------+-------+-------+-------+-------+---| | # | 1 | 10 | 2.8 | 28.00 | 33.60 | | | # | 2 | 12 | 0.7 | 8.40 | 2.80 | | | # | 3 | 4 | 4.00 | 16.00 | 0.00 | | |---+------+-------+-------+-------+-------+---| | _ | | | | suma | sumb | | | | | | | 52.40 | 36.4 | | #+TBLFM: $6=@+1$3*$4;%.2f::$sumb=vsum(@II..@III) ...but you may not want to calculate the last value, since there is no "Menge" value to calculate it with. Something like this would calculate only the first two rows: #+TBLFM: @2$6..@3$6=@+1$3*$4;%.2f::$sumb=vsum(@II..@III) Yours, Christian Thorsten Grothe writes: > Hello, > > I would like to assign a relative column formular for the 6 column (name > = BIPr). > > The formular should start in the *second field* of column 3 (value = 12) > and multiply it with *first value of column* 4 (value = 2.8) etc. like this: > > 12 * 2.8 > 4 * 0.7 > ... > > |---+------+-------+-------+-------+-------+---| > | ! | Jahr | Menge | Preis | BIPn | BIPr | W | > |---+------+-------+-------+-------+-------+---| > | # | 1 | 10 | 2.8 | 28.00 | 0 | | > | # | 2 | 12 | 0.7 | 8.40 | | | > | # | 3 | 4 | 4.00 | 16.00 | | | > |---+------+-------+-------+-------+-------+---| > | _ | | | | suma | sumb | | > | | | | | 52.40 | 16.00 | | > > How can I do this? > > Thanks in advance for your help!! > > Regards > Thorsten Grothe
