Need help with creating Dynamic Array solution for exam check

[Miron]

Trying to create Dynamic Array solution but its not working.
Column F is regular solution
Column G is DA solution.

and-or-xor-not.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	Name	Exam 1	Exam 2	Exam 3	Coursework	Result	DA Result			Pass Ctriteria
2	Emily	57	80	64	75%	Fail	Pass			Average 1-3 is =>		75.00
3	Andreas	91	60	69	81%	Pass	Pass			Coursework is =>		80%
4	Jan	88	74	83	85%	Pass	Pass
5	Rachel	88	95	89	76%	Pass	Pass
6	Alexandra	89	71	74	92%	Pass	Pass
7	Jason	72	89	82	68%	Pass	Pass
8	Claire	55	74	93	90%	Pass	Pass
9	Tony	95	75	81	86%	Pass	Pass
AND 2

Cell Formulas
Range	Formula
F2:F9	F2	=IF(OR(AVERAGE(B2:D2)>=$L$2,E2>=$L$3),"Pass","Fail")
G2:G9	G2	=IF(OR(BYROW($B$2:$D$9,LAMBDA(array,AVERAGE(array)))>=$L$2,BYROW($E$2:$E$9,LAMBDA(array,array>=$L$3))),"Pass","Fail")

 

[Miron]

This is solution for simpler test where I check only one result. Its spills successfully.

and-or-xor-not.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Name	Exam 1	Exam 2	Exam 3	Result	DA Result	Check			Pass Grade
2	Emily	57	80	64	Fail	Fail	TRUE			80
3	Andreas	91	60	69	Fail	Fail	TRUE
4	Jan	88	74	83	Pass	Pass	TRUE
5	Rachel	88	95	89	Pass	Pass	TRUE
6	Alexandra	89	71	74	Fail	Fail	TRUE
7	Jason	72	89	82	Pass	Pass	TRUE
8	Claire	55	74	93	Fail	Fail	TRUE
9	Tony	95	75	81	Pass	Pass	TRUE
AND 1

Cell Formulas
Range	Formula
F2:F9	F2	=IF(BYROW(B2:D9,LAMBDA(array,AVERAGE(array)))>=J2,"Pass","Fail")
G2:G9	G2	=F2#=E2:E9
E2:E9	E2	=IF(AVERAGE(B2:D2)>=$J$2,"Pass","Fail")
Dynamic array formulas.

 

[Fluff]

You need to use the array form of OR like

=IF((BYROW($B$2:$D$9,LAMBDA(array,AVERAGE(array)))>=$L$2)+(BYROW($E$2:$E$9,LAMBDA(array,array>=$L$3))),"Pass","Fail")

 

[Miron]

To anyone wondering why this solution works. I found explanation on Microsoft website.
This is the relevant text from MS website.

You can also create array formulas that use a type of OR condition. For example, you can sum values that are greater than 0 OR less than 2500:

=SUM(IF((Sales>0)+(Sales<2500),Sales))

You can't use the AND and OR functions in array formulas directly because those functions return a single result, either TRUE or FALSE, and array functions require arrays of results. You can work around the problem by using the logic shown in the previous formula. In other words, you perform math operations, such as addition or multiplication on values that meet the OR or AND condition.

 

[Fluff]

Glad to help & thanks for the feedback.