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"
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"