| A | B |
|---|
| IF statements | conditional operator: checks whether a condition is met and returns one value if TRUE and another value if FALSE |
| date functions | used to calculate a period of time |
| NOW | date function that returns the current date |
| Days360 | date function that calculates the difference in days between two dates |
| LookUp function | used to compare a cell value to an array of cells (lookup table) and return a value that matches the location of the value in the array; used for two column vectors |
| VLookUp | used to compare a cell value to an array of cells and return a value; used when there are more than two columns in the array (lookup table); searches for matches according to column number |
| List | used to assist in organizing spreadsheet information; controls the size or content of data entries; allows filtering for specific content - provides a drop down menu for data entry |
| validated | list that limits data entry to specific choices programmed into the function |
| non-validated | list that allows additional entries other than those provided in the drop-down menu |
| count function | used to return the number of cells in a range |
| Count | returns the number of cells in a range that contain numbers |
| CountA | function that returns the number of cells in a range that contain any value or label: non-blank cells |
| CountIF | function that will return the number of cells that meet a condition set forth in the formula |
