Excel Add if formula

[gero92]

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!!

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>

 

[MARK858]

One way, formula in D3 and dragged down.

Excel Workbook
	A	B	C	D
1	Date	Value	Cumulative	FORMULA
2	10/07/2018	0.3
3	04/08/2018	0.65	0.95
4	25/09/2018	0.23	1.18	1
5	28/09/2018	0.56	1.74
6	07/11/2018	0.78	2.52	1
7	28/11/2018	0.2	2.72
8	19/12/2018	0.7	3.42	1
Sheet1

 

[Peter_SSs]

.. or if you are trying to do it without the third column:

Excel Workbook
	A	B	C	D
1	Date	Value		FORMULA
2	10/07/2018	0.3
3	4/08/2018	0.65
4	25/09/2018	0.23		1
5	28/09/2018	0.56
6	7/11/2018	0.78		1
7	28/11/2018	0.2
8	19/12/2018	0.7		1
Sheet6