Hi , i have a formula where values need to be divivded into 3 equal numbers rounded with two decimals:
Like
38/3 = 12,67
However as i need the value to be the same as the value before the split, i need to remove 00,01 on one of the values named 12,67, how do i manage that? - its not important which row will recieve it
[TABLE="width: 500"]
<tbody>[TR]
[TD]Order[/TD]
[TD]Value[/TD]
[TD]Split[/TD]
[TD]Correct split[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]38[/TD]
[TD]12,67[/TD]
[TD]12,67[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD][/TD]
[TD]12,67[/TD]
[TD]12,67[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD][/TD]
[TD]12,67[/TD]
[TD]12,66[/TD]
[/TR]
</tbody>[/TABLE]
Like
38/3 = 12,67
However as i need the value to be the same as the value before the split, i need to remove 00,01 on one of the values named 12,67, how do i manage that? - its not important which row will recieve it
[TABLE="width: 500"]
<tbody>[TR]
[TD]Order[/TD]
[TD]Value[/TD]
[TD]Split[/TD]
[TD]Correct split[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]38[/TD]
[TD]12,67[/TD]
[TD]12,67[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD][/TD]
[TD]12,67[/TD]
[TD]12,67[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD][/TD]
[TD]12,67[/TD]
[TD]12,66[/TD]
[/TR]
</tbody>[/TABLE]