"IF" with an "AND"

[UpTheArgyle]

Hi i have a formula that compares a column of dates and returns the value "OK" if the upper column is the same value as the lower column.

I want the OK to be returned only if C2 is = C3 AND C1

The cells above and below

Current Formula

=IF(C2=C3, "OK", "")


Any ideas?

Thanks

 

[VoG]

Try

=IF(AND(C2=C1,C2=C3), "OK", "")