Hi,
=if(and(c18=c20,c18=c16),1,0)

"Fan924" wrote:

How do I word a worksheet function where both of these is true,
IF C18=C20 AND IF C18=C16
gives a 1, not it gives a 0