Try the below...The new condition is again within the same IF

=IF(OR(AND(C10=C12,C10=C14),AND(C10=C12,C10=C8)),1 ,0)

OR

=IF(AND(C10=C12,OR(C10=C14,C10=C8)),1,0)


If this post helps click Yes
---------------
Jacob Skaria


"Fan924" wrote:

Thanks, works great.
How about something more complex? I get an error with all I try

IF(AND(C10=C12,C10=C8),1,0) OR IF(AND(C10=C12,C10=C14),1,""),1,0)
returns a 1 of 0