Nested IF And/OR statement

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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!