Oops, I did misunderstand. I think this is what you wanted: |---+------+-------+-------+-------+-------+---| | ! | Jahr | Menge | Preis | BIPn | BIPr | W | |---+------+-------+-------+-------+-------+---| | # | 1 | 10 | 2.8 | 28.00 | 0 | | | # | 2 | 12 | 0.7 | 8.40 | 33.60 | | | # | 3 | 4 | 4.00 | 16.00 | 2.80 | | |---+------+-------+-------+-------+-------+---| | _ | | | | suma | sumb | | | | | | | 52.40 | 36.4 | | #+TBLFM: $6=$3*@-1$4;%.2f::@2$6=0::$sumb=vsum(@II..@III)
Here I add a formula to set the first row to 0. Yours, Christian > 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