return Yes or No after meeting several criteria

[EddyFame]

Greetings all. First post here and wanted to say this is a great network. glad to have found you all. i'm currently putting a report together that indicates where all the rows meets specific criteria. (age, location, time in residence, etc.)
is it possible to write a formula that checks each column N:S in a row to make it say Yes or No if they were all met my criteria? example would be a Male, over 80, had a policy for 20, and spousal_link?
there's plenty of other requirements but i think i can figure out how to add them once i learn the formula below. TYIA. EF

01-06-2020_(B)_Master-Data.xlsx
	N	O	P	Q	R	S
1	Gender	DOB	Current_Age	Policy_Duration	Spousal_Ind	Spousal_Link
2	F	06-May-37	82.66119	22.507871	N	N
3	M	27-Feb-36	83.849418	22.507871	N	Y
Master File

 

[DanteAmor]

Hi and welcome to MrExcel.
How about:

varios 19mar2020.xlsm
	N	O	P	Q	R	S	T
1	Gender	DOB	Current_Age	Policy_Duration	Spousal_Ind	Spousal_Link	Formula
2	F	05/06/1937	82.66119	22.507871	N	N	No
3	M	2/27/1936	83.849418	22.507871	N	Y	Yes
Hoja13

Cell Formulas
Range	Formula
T2:T3	T2	=IF(AND(N2="M",P2>=80,Q2>=20,S2="Y"),"Yes","No")

 

[EddyFame]

Hi and Thank you.
how do i include multiple entries in one column. for example, if N2="M" but i also want to include a blank and a U (unknown)?

 

[DanteAmor]

Try this

=IF(AND(OR(N2={"M","","U"}),P2>=80,Q2>=20,S2="Y"),"Yes","No")