IF

[RussChilds]

Hi

I have 3 columns (A,B & C) that have either "Yes" or "No" in. In Coloumn D I want to say If A, B & C all have Yes in them for it say "Complete".

Can you help?
Many thanks!

 

[Domski]

Like this:

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

or

=IF(COUNTIF($A$1:$C$1,"Yes")=3,"Complete","")

Dom

 

[RussChilds]

Thanks!!!!!

 

[Peter_SSs]

... or maybe this?

=IF(A1&B1&C1="YesYesYes","Complete,"")

 

[Domski]

... or maybe this?

=IF(A1&B1&C1="YesYesYes","Complete,"")

You might get some When Harry Met Sally fan typing YesYesYes in A1 though

 

[Peter_SSs]

You might get some When Harry Met Sally fan typing YesYesYes in A1 though

Yes, I thought of that, but took this to be true:

... columns (A,B & C) that have either "Yes" or "No" in