|The Excel help files explain both of these functions very well. I quote:|
OR: Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.
AND: Returns TRUE if all its arguments evaluate to TRUE; returns FALSE if one or more arguments evaluate to FALSE.
In other words...
OR will return TRUE if any one or more of the arguments are TRUE.
AND will return TRUE only if all of the arguments are TRUE.
For the OR to return TRUE:
W15 contains Y
X15 contains N
W15 contains Y and X15 contains N
For the AND to return TRUE:
W15 contains Y AND X15 contains N.
Therefore, you will see no difference between your formulas if both W15 contains Y and X15 contains N since both the OR and the AND functions will be TRUE.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.