How to display result by skipping blank columns

[nskatoch]

A​	B​	C​	D​	E​	F​	G​	H​
STUDENT NO​	ENGLISH​	PHYSICS​	CHEMISTRY​	MATHS​	BIO​	IT​	RESULT​
1​	33​	45​	​	32​	​	43​	​
2​	31​	32​	33​	​	21​	​	​
3​	45​	34​	23​	​	​	37​	​
4​	​	​	​	​	​	​	​

If student obtained greater than and equal to 33 marks then print result “PASS” in H column otherwise print fails in that subject in which mark obtained less than 33. Also, some cells are blank.

e.g. STUDENT No. 2, obtained less than 33 marks in ENGLISH, PHYSICS and in BIO. Also, MATH & IT cells are blanked, the result should be FAILS IN ENGLISH, PHYSICS, BIO.

Please suggest a formula.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H
1	STUDENT NO	ENGLISH	PHYSICS	CHEMISTRY	MATHS	BIO	IT	RESULT
2	1	33	45		33		43	Pass
3	2	31	32	33		21		Fails in ENGLISH, PHYSICS, BIO
4	3	45	34	23			37	Fails in CHEMISTRY
5	4
Main

Cell Formulas
Range	Formula
H2:H5	H2	=IF(COUNT(B2:G2)=0,"",IF(COUNTIFS(B2:G2,">=33")=COUNT(B2:G2),"Pass","Fails in "&TEXTJOIN(", ",,FILTER($B$1:$G$1,(B2:G2<33)*(B2:G2<>"")))))

 

[nskatoch]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H
1	STUDENT NO	ENGLISH	PHYSICS	CHEMISTRY	MATHS	BIO	IT	RESULT
2	1	33	45		33		43	Pass
3	2	31	32	33		21		Fails in ENGLISH, PHYSICS, BIO
4	3	45	34	23			37	Fails in CHEMISTRY
5	4
Main

Cell Formulas
Range	Formula
H2:H5	H2	=IF(COUNT(B2:G2)=0,"",IF(COUNTIFS(B2:G2,">=33")=COUNT(B2:G2),"Pass","Fails in "&TEXTJOIN(", ",,FILTER($B$1:$G$1,(B2:G2<33)*(B2:G2<>"")))))

Thanks.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How to calculate result by skipping blank cells
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

If this is not working, why did you not say so, rather than posting to a different forum?