Hello everybody,
I am trying to get the 4th column of the below table with a formula. Basically I want in the fourth column to have the value 1 when the sum of the values in the second column is 1 or a multiple of 1. Can someone help me please? Thank you so much!!
<tbody>
</tbody>
I am trying to get the 4th column of the below table with a formula. Basically I want in the fourth column to have the value 1 when the sum of the values in the second column is 1 or a multiple of 1. Can someone help me please? Thank you so much!!
Date | Value | Cumulative | FORMULA |
10/07/2018 | 0,3 | ||
04/08/2018 | 0,65 | 0,95 | |
25/09/2018 | 0,23 | 1,18 | 1 |
28/09/2018 | 0,56 | 1,74 | |
07/11/2018 | 0,78 | 2,52 | 1 |
28/11/2018 | 0,2 | 2,72 | |
19/12/2018 | 0,7 | 3,42 | 1 |
<tbody>
</tbody>