Hi there,
I'm looking to get the sum of a row until it's >= 0.5 then have it start over again. For values that are already >= 0.5 I'd like to have the value rounded up. I've provided an example below. I'm hoping to get the output in the last 7 columns.
<tbody>
</tbody>
Thanks in advance.
I'm looking to get the sum of a row until it's >= 0.5 then have it start over again. For values that are already >= 0.5 I'd like to have the value rounded up. I've provided an example below. I'm hoping to get the output in the last 7 columns.
D1 | D2 | D3 | D4 | D5 | D6 | D7 | D1' | D2' | D3' | D4' | D5' | D6' | D7' |
0.142857 | 0.142857 | 0.142857 | 0.142857 | 0.142857 | 0.142857 | 0.142857 | 1 | ||||||
0.285714 | 0.285714 | 0.285714 | 0.285714 | 0.285714 | 0.285714 | 0.285714 | 1 | 1 | 1 | ||||
0.714286 | 0.714286 | 0.714286 | 0.714286 | 0.714286 | 0.714286 | 0.714286 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
2.571429 | 2.571429 | 2.571429 | 2.571429 | 2.571429 | 2.571429 | 2.571429 | 3 | 3 | 3 | 3 | 3 | 3 | 3 |
<tbody>
</tbody>
Thanks in advance.