Hi Thorsten,
Thorsten Grothe writes:
> No one an idea?
Let's have a habit of waiting at least two days before
bumping a thread. Thanks!
--
Bastien
Am 31.08.2014 um 09:59 schrieb Christian Moe:
Here I add a formula to set the first row to 0.
I testet your formular and it works fine! Thank you very much for your
help!!
Regards
Thorsten
Am 31.08.2014 um 09:59 schrieb Christian Moe:
Oops, I did misunderstand. I think this is what you wanted:
|---+--+---+---+---+---+---|
| ! | Jahr | Menge | Preis | BIPn | BIPr | W |
|---+--+---+---+---+---+---|
| # |1 |10 | 2.8 | 28.00 | 0
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.6
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 | |
| #
No one an idea?
Regards
Thorsten Grothe
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
...
|---+--+---+---+--