Excel : Fill the fourth column based on the value on other three columns

Question

I'm looking for a solution to this problem

On the same sheet, I have three columns with rows of Yes and No.I need my fourth column to have an Yes if only all the three preceding columns have Yes, else No.

I wrote this formula, D1 =If(A1=Yes and B1=Yes and C1=Yes, "Yes", "No") but the value returns a #NAME? error. Can you please help ?

@Mrig, I used the formula but don't know why isn't working

Answer 1

Your formula should be

=IF(AND(A1="Yes",B1="Yes",C1="Yes"), "Yes", "No")

For details on AND function see this.

See image for reference.