Okey, I don't think my problem is very complicated, but it's seems to be difficult to explain, so I have tried to make it clearer with the help of a picture.
My setup is the following:
I have a very long list of values in a column (column J). All these values are calculated in accordance with an input value, which is currently given in a single cell (P3).
This is the code of the first cell in the J-column:
Now I would like to make a new column, where the first cell calculates the sum of the original column for an input value "0".
Then the second cell in this column calculates the of the original column for an input value "100".
Then the same with an input value 200, then 300 and so on.
My setup is the following:
I have a very long list of values in a column (column J). All these values are calculated in accordance with an input value, which is currently given in a single cell (P3).
This is the code of the first cell in the J-column:
Code:
=WENN(H2+F3>$P$3;(H2+F3)-$P$3;0)
Then the second cell in this column calculates the of the original column for an input value "100".
Then the same with an input value 200, then 300 and so on.