IF Statement Formula Assistance

[bdav1216]

How would I write this?

When Column A has the same value.:

IF Column M OR Column P = "YES" AND Column N, O, Q, R AND S are = "N" or No", output "SS" in Column T
Else
IF Column M or Column P = "No" or "N" AND any of Column N, O, Q, R AND S are = "YES", output "No SS" in Column T
Else
If Column M OR Column P = "YES" AND any of Column N, O, Q R AND S are = "YES", output "Hybrid" in Column T
Else
IF all Columns (M, N, O, P, Q, R, S) are = "N" or "No", output "None"

 

[maabadi]

Use this Formula At T1 and drag it down:

=IF(AND(OR(M1="Yes",P1="Yes"),OR(AND(N1="No",O1="No",Q1="No",R1="No",S1="No"),AND(N1="N",O1="N",Q1="N",R1="N",S1="N"))),"SS",IF(AND(OR(M1="No",P1="No",M1="N",P1="N"),AND(N1="Yes",O1="Yes",Q1="Yes",R1="Yes",S1="Yes")),"NO SS",IF(AND(OR(M1="Yes",P1="Yes"),AND(N1="Yes",O1="Yes",Q1="Yes",R1="Yes",S1="Yes")),"Hybrid",IF(AND(OR(M1="No",P1="No",M1="N",P1="N"),OR(AND(N1="No",O1="No",Q1="No",R1="No",S1="No"),AND(N1="N",O1="N",Q1="N",R1="N",S1="N"))),"None",""))))

 

[bdav1216]

Hello,

Most of that examples are not outputting a value so wanted to provide a few examples:

The 'SS' and 'NONE' value appears to be outputting, but am not getting values for 'No SS' or 'Hybrid'

COLUMN M	COLUMN N	COLUMN O	COLUMN P	COLUMN Q	COLUMN R	COLUMN S	CURRENT RESULT	EXPECTED RESULT
YES	NO	NO	YES	NO	NO	NO	SS	SS
NO	YES	NO	N	N	N	N	___	NO SS
NO	NO	NO	NO	NO	NO	YES	___	NO SS
YES	NO	NO	NO	NO	YES	NO	___	HYBRID
N	N	N	N	N	N	N	NONE	NONE
NO	NO	NO	NO	NO	NO	YES	___	NO SS
NO	NO	NO	YES	NO	NO	NO	SS	SS
YES	NO	NO	YES	NO	NO	NO	SS	SS
NO	NO	NO	YES	NO	YES	NO	___	HYBRID
NO	YES	NO	N	N	N	N	___	NO SS
YES	NO	NO	NO	NO	YES	NO	___	HYBRID

 

[maabadi]

Change formula to this (I don't noticed "Any"):

=IF(AND(OR(M1="Yes",P1="Yes"),OR(AND(N1="No",O1="No",Q1="No",R1="No",S1="No"),AND(N1="N",O1="N",Q1="N",R1="N",S1="N"))),"SS",IF(AND(OR(M1="No",P1="No",M1="N",P1="N"),OR(N1="Yes",O1="Yes",Q1="Yes",R1="Yes",S1="Yes")),"NO SS",IF(AND(OR(M1="Yes",P1="Yes"),OR(N1="Yes",O1="Yes",Q1="Yes",R1="Yes",S1="Yes")),"Hybrid",IF(AND(OR(M1="No",P1="No",M1="N",P1="N"),OR(AND(N1="No",O1="No",Q1="No",R1="No",S1="No"),AND(N1="N",O1="N",Q1="N",R1="N",S1="N"))),"None","")))