Closed undying closed 4 years ago
I'm trying to evaluate the formula $5=($1,2*$2)+($1,3*$3)+($1,4*$4) for this kind of table:
$5=($1,2*$2)+($1,3*$3)+($1,4*$4)
| | USD | EUR | RUB | Total | |--|-----|-----|-------|----------| | | 79 | 92 | 1 | 0 | |--|-----|-----|-------|----------| | | 0 | 550 | 0 | 50600.0 | |--|-----|-----|-------|----------| | | 0 | 0 | 25000 | 25000.0 | |--|-----|-----|-------|----------| | | 350 | 0 | 0 | 27650.0 | |--|-----|-----|-------|----------| | | 0 | 0 | 23600 | 23600.0 | |--|-----|-----|-------|----------| | | 0 | 0 | 0 | 0.0 | |--|-----|-----|-------|----------| | | 0 | 0 | 0 | | |--|-----|-----|-------|----------| | | 0 | 0 | 0 | | |--|-----|-----|-------|----------| | | 0 | 0 | 0 | | |--|-----|-----|-------|----------| | | | | | 126850.0 | <!-- tmf: $5=($1,2*$2)+($1,3*$3)+($1,4*$4);$10,-1=Sum(2,5:9,5);$1,5=0 -->
Expected behaviour is that each cell in the 5 column will be filled. But it's working only for the first row. To evaluate for every row I have to write formula in $n,m mode for every row.
It seems to be fixed in master, thanks :)
I'm trying to evaluate the formula
$5=($1,2*$2)+($1,3*$3)+($1,4*$4)
for this kind of table:Expected behaviour is that each cell in the 5 column will be filled. But it's working only for the first row. To evaluate for every row I have to write formula in $n,m mode for every row.