| A | B |
|---|
| IF Statements | Conditional operators. results are returned IF the data specified in an equation meets conditions set by the formula. Written to carry out an action. |
| Date functions | Used to calculate a period of time. |
| NOW | Returns the current date |
| Days360 | Calculates difference in days between two dates. |
| LookUp function | Used to compare cell value to an array of cells and return a value that matches the location of the value in the array. |
| Lookup | Used for two column vectors. |
| VLookUp | Used when there are more than two columns in the array (lookup table). |
| List | Used to control the size or content of data entries and filter for specific content within a list. Organizing spreadsheet information. |
| Validated | Limits data entry to specific choices programmed into the function |
| Non-validated | Allows additional entries other then those provided in the drop-down menu. |
| Count | Used to return the number of cells in a range that contain numbers. |
| CountA | Number cells in a range that contain value of letter. |
| CountIf | Cells that meet a condition set forth in the formula. |
