Dynamic formula - Find the first negative value and turn the subsequent rows 0

[Cubist]

Given a dynamic array of numerical values.
The array always starts with positive values. Once it turns negative, the remaining rows will be negative.
I want to turn the first negative value positive and the subsequent negative values into 0.
I'm looking for a dynamic array solution that can handle both cases below. TIA

Book1
	A	B	C	D	E	F
1	Case 1	Expected		Case 2	Expected
2	15	15		0	0
3	35	35		0	0
4	15	15		0	0
5	26	26		0	0
6	11	11		0	0
7	18	18		0	0
8	-45	45		0	0
9	-29	0		0	0
10	-6	0		0	0
11	-6	0		0	0
12	-27	0		0	0
13	-25	0		0	0
14	-27	0		0	0
15	-19	0		0	0
16	-6	0		0	0
17
Sheet5

Cell Formulas
Range	Formula
A2:A16	A2	={15;35;15;26;11;18;-45;-29;-6;-6;-27;-25;-27;-19;-6}
B2:B7	B2	=A2:A7
D2:D16	D2	=SEQUENCE(15,1,0,0)
Dynamic array formulas.

 

[Peter_SSs]

The array always starts with positive values.

That doesn't appear to be the situation with Case 2.

Anyway, try this

24 03 25.xlsm
	A	B	C	D	E
1	Case 1	Expected		Case 2	Expected
2	15	15		0	0
3	35	35		0	0
4	15	15		0	0
5	26	26		0	0
6	11	11		0	0
7	18	18		0	0
8	-45	45		0	0
9	-29	0		0	0
10	-6	0		0	0
11	-6	0		0	0
12	-27	0		0	0
13	-25	0		0	0
14	-27	0		0	0
15	-19	0		0	0
16	-6	0		0	0
Cubist

Cell Formulas
Range	Formula
A2:A16	A2	={15;35;15;26;11;18;-45;-29;-6;-6;-27;-25;-27;-19;-6}
B2:B16,E2:E16	B2	=LET(r,A2#,IF(r>=0,r,IF(OFFSET(r,-1,0)>0,-r,0)))
D2:D16	D2	=SEQUENCE(15,1,0,0)
Dynamic array formulas.

 

[Peter_SSs]

Looking back at this, my formula might not meet the requirements as shown in the example below. For this sample data my previous formula (col B) fails to turn the first negative into positive so amended formula given in col C.

24 03 25.xlsm
	A	B	C
1	Case 1	Expected
2	15	15	15
3	35	35	35
4	15	15	15
5	26	26	26
6	11	11	11
7	0	0	0
8	-45	0	45
9	-29	0	0
10	-6	0	0
11	-6	0	0
12	-27	0	0
13	-25	0	0
14	-27	0	0
15	-19	0	0
16	-6	0	0
Cubist (2)

Cell Formulas
Range	Formula
A2:A16	A2	={15;35;15;26;11;0;-45;-29;-6;-6;-27;-25;-27;-19;-6}
B2:B16	B2	=LET(r,A2#,IF(r>=0,r,IF(OFFSET(r,-1,0)>0,-r,0)))
C2:C16	C2	=LET(r,A2#,IF(r>=0,r,IF(OFFSET(r,-1,0)>=0,-r,0)))
Dynamic array formulas.

 

[Cubist]

I meant to say 0 or positive values. This works. Thanks!

 

[Peter_SSs]

You're welcome. Thanks for the confirmation.