Forum Discussion
Solved
linear progression
Hello guys, do you have any idea how to easily add a fixed increment? The only thing I can think of is the if function, but I have several thousand rows and would prefer to streamline it 🙂 Simple data:
| x | y |
| 1255 | 1 |
| 2545 | 0,99 |
| 3555 | 0,98 |
| 4787 | 0,97 |
| 6222 | 0,95 |
| 6565 | 0,95 |
| 8855 | 0,93 |
| 9001 | 0,91 |
| 9655 | 0,91 |
I would like the function, after x increases by 1000, to subtract 0.01 from y. This can be as a new column or function, of your choice.
3 Replies
Because the range is between 0-1000, 1001-2000, in the second example there is an error. let's make it simple. For numbers < 1000-1, between 1001-2000=0,99, between 2001-3000=0,98 and so on
