Nested IF And/OR statement

Tsega Thompson

I am trying to create a formula that will give me something similiar to the below:

If (A1=A) and (B1=A) and (C1=A) then (D1=A),

If (A1=D) or (B1=D) or (C1=D) then (D1=D),

Otherwise D1=S

Paul Newcome

Try this...

=IF(AND(A1 = "A", B1 = "A", C1 = "A"), "A", IF(OR(A1 = "D", B1 = "D", C1 = "D"), "D", "S"))

Paul Newcome

Try this...

=IF(AND(A1 = "A", B1 = "A", C1 = "A"), "A", IF(OR(A1 = "D", B1 = "D", C1 = "D"), "D", "S"))

Tsega Thompson

Thanks Paul, that worked perfectly!

Paul Newcome

Happy to help. 👍️