you dont need to use a nested if

=(and(A1=D1,B1=E1),C1, "otherwise")
"jmsbert" wrote:

How can I compare value in column A to column D and also compare column B to
column E? If A & D agree and B & E agree, return value of column C.

Thank you!