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
<tbody>
</tbody>
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
Order | Value | Split | Correct split |
A1 | 38 | 12,67 | 12,67 |
A2 | 12,67 | 12,67 | |
A3 | 12,67 | 12,66 |
<tbody>
</tbody>