convert the values to integer and add the decimals to the next cell
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.
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.
For example:
if the X and Y columns as follows:
X Y
1.5 15
2.6 30
3.1 10
4.2 20
5.7 10
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.
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.
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)
Bookmarks