[FONT="]if I have two columns, let me assume its name as X and Y. The X column has decimals in every cell value. --> I want to make the X values as integer numbers by adding the decimal part to the next cell value until the end of the column. --> sure the decimal part present a percentage from the original cell value, So I want to shift the same percentage from the Y column to the next cell.[/FONT]
[FONT="]for example: if the X and Y columns as follow:[/FONT]
[FONT="]in this case for the X Column values--> the first values will be in values of 1, and the 0.5 will be added to the next cell (2.6), now the cell (2.6) will be (2.6 + 0.5 = 3.1) so the second cell will in value of 3 and the part 0.1 will be added to the next cell ... and so on.[/FONT]
[FONT="]But, in the first cell, we shifted 0.5, its = 33% from the original value, so it's required to shift also 33% from the opposite Y value to the next one, in this case, the first cell from Y column will be (15-5=10), and the value of 5 will be added to the next cell (30) to be (30+5=35) in the second Y Cell.[/FONT]
[FONT="]summary: -->shift the decimals part to the next. (X have to be an integer) --> shift the Y values by the same percentage (not required to be an integer or not)
[/FONT]
<tbody>
</tbody>
[FONT="]for example: if the X and Y columns as follow:[/FONT]
[FONT="]in this case for the X Column values--> the first values will be in values of 1, and the 0.5 will be added to the next cell (2.6), now the cell (2.6) will be (2.6 + 0.5 = 3.1) so the second cell will in value of 3 and the part 0.1 will be added to the next cell ... and so on.[/FONT]
[FONT="]But, in the first cell, we shifted 0.5, its = 33% from the original value, so it's required to shift also 33% from the opposite Y value to the next one, in this case, the first cell from Y column will be (15-5=10), and the value of 5 will be added to the next cell (30) to be (30+5=35) in the second Y Cell.[/FONT]
[FONT="]summary: -->shift the decimals part to the next. (X have to be an integer) --> shift the Y values by the same percentage (not required to be an integer or not)
[/FONT]
x | y |
1.5 | 15 |
2.6 | 30 |
3.1 | 10 |
4.2 | 20 |
5.7 | 10 |
6.2 | 20 |
7.1 | 30 |
8.3 | 15 |
<tbody>
</tbody>