# Visual Basic for Applications Reference

# And Operator

Used to perform a logical conjunction on two expressions.

**Syntax**

*result***=***expression1***And***expression2*

The **And** operator syntax has these parts:

Part |
Description |

result |
Required; any numeric variable. |

expression1 |
Required; any expression. |

expression2 |
Required; any expression. |

**Remarks**

If both expressions evaluate to **True**, *result* is **True**. If either expression evaluates to **False**, *result* is **False.** The following table illustrates how *result* is determined:

If expression1 is |
And expression2 is |
The result is |

True |
True |
True |

True |
False |
False |

True |
Null | Null |

False |
True |
False |

False |
False |
False |

False |
Null |
False |

Null |
True |
Null |

Null |
False |
False |

Null |
Null |
Null |

The **And** operator also performs a bitwise comparison of identically positioned bits in two numeric expressions and sets the corresponding bit in *result* according to the following table:

If bit in expression1is |
And bit in expression2 is |
The result is |

0 | 0 | 0 |

0 | 1 | 0 |

1 | 0 | 0 |

1 | 1 | 1 |