Allowed figures based on set limit

[ExcelNewbie2020]

i have this table below (actual vs allowed).

I need a formula in allowed column based on the following condition

if the value of succeeding month did not reach the set limit (5 or -5). the value of the previous month will carry over.
if the value of succeeding month reach the set limit (5 or -5). the value of the suceeding month will prevail..

Name-List-for-Practice.xlsm
	I	J	K	L	M	N	O	P
2
3			FORMULA HERE
4	Month	Actual	Allowed
5	january	45	45			LIMIT	5	-5
6	february	47	45
7	march	48	45
8	april	51	51
9	may	59	59
10	june	60	59
11	july	62	59
12	august	65	65
13	september	50	50
14	october	52	50
15	november	51	50
16
17
Sheet17

 

[Sanjeev1976]

Hi

You can try the below :

Book1
	A	B	C	D	E	F	G	H
1
2			FORMULA HERE
3	Month	Actual	Allowed
4	january	45	45			LIMIT	5	-5
5	february	47	45
6	march	48	45
7	april	51	51
8	may	59	59
9	june	60	59
10	july	62	59
11	august	65	65
12	september	50	50
13	october	52	50
14	november	51	50
Sheet1

Cell Formulas
Range	Formula
C4	C4	=B4
C5:C14	C5	=IF(OR(B5-C4<$H$4,B5-C4>$G$4),B5,C4)

 

[ExcelNewbie2020]

Hi

You can try the below :

Book1
	A	B	C	D	E	F	G	H
1
2			FORMULA HERE
3	Month	Actual	Allowed
4	january	45	45			LIMIT	5	-5
5	february	47	45
6	march	48	45
7	april	51	51
8	may	59	59
9	june	60	59
10	july	62	59
11	august	65	65
12	september	50	50
13	october	52	50
14	november	51	50
Sheet1

Cell Formulas
Range	Formula
C4	C4	=B4
C5:C14	C5	=IF(OR(B5-C4<$H$4,B5-C4>$G$4),B5,C4)

thanks man, it worked