# CIS105: Computer Applications & Information Systems Lect. 6 Pt. 2

## Chapter 6: Logical Functions

### 6.1: New Functions

-   `AND`: Checks whether all arguments are `TRUE`, and returns `TRUE` if all arguments are `TRUE`.
-   `OR`: Checks whether any of the arguments are `TRUE`, and returns `TRUE` or `FALSE`.
-   `NOT`: Changes `TRUE` to `FALSE`, or `FALSE` to `TRUE`.
-   `IF`: Checks whether a condition is met, and returns one value if `TRUE`, and another value if `FALSE`.

    -   Nested `IF`: Using multiple `IF` statements in one functions to account for multiple conditions.

-   `VLOOKUP`: Looks for a value in a table or a range veryically
    -   `VLOOKUP` What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an approximate or exact match: Indicates as `1/TRUE`, or `0/FALSE`.
-   `HLOOKUP`: Looks for a value in a table or a range horizontally.
-   `COUNTIF`: Counts the number of cells within a range that meet the given condition.
    -   `=COUNTIF(Where do you want to look? What do you want to look for?)`
-   `SUMIF`: Adds the cells specified by a given condition or criteria.
-   `AVERAGEIF`: s an Excel Statistical function, which calculates the average of a given range of cells by a specific criterion.

### 6.2: Comparison Operators

-   `>`: More than
-   `<`: Less than
-   `>=`: More than or equal to
-   `<=`: Less that or equal to

### 6.3: Reminder

-   **Excel does not recognize tex**
    -   When searching for keywords, put keyword between `""` delimiters.