# CIS105: Computer Applications & Information Systems Lect. 6 Pt. 2 | Toshiki's Note
Toshiki's web notebook served via Vitepress!
Author: Anda Toshiki
Keywords: Toshiki, Anda Toshiki, andatoshiki, GitHub, GitHub action, Vitepress, Vite, Notebook, Knowledge base, Programming, Programming Notes, Academic, Personal, Notebook, Productivity, Journal, Note-taking, Markdown, Notepad, Organization, Tutorial

Skip to content

####

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

Author:Anda Toshiki
Updated:a minute ago
Words:249
Reading:1 min

## 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.