IF/AND worksheet function
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
|