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


[TABLE="width: 281"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Value[/TD]
[TD]Cumulative[/TD]
[TD] FORMULA[/TD]
[/TR]
[TR]
[TD="align: right"]10/07/2018[/TD]
[TD="align: right"]0,3[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]04/08/2018[/TD]
[TD="align: right"]0,65[/TD]
[TD="align: right"]0,95[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]25/09/2018[/TD]
[TD="align: right"]0,23[/TD]
[TD="align: right"]1,18[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]28/09/2018[/TD]
[TD="align: right"]0,56[/TD]
[TD="align: right"]1,74[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]07/11/2018[/TD]
[TD="align: right"]0,78[/TD]
[TD="align: right"]2,52[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]28/11/2018[/TD]
[TD="align: right"]0,2[/TD]
[TD="align: right"]2,72[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]19/12/2018[/TD]
[TD="align: right"]0,7[/TD]
[TD="align: right"]3,42[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

 

[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