Revision history [back]
 | 1 | initial version |
- SUM – calculates the sum of a range of cells
- IF – checks whether a condition is met, and returns one value if true, and another value if false
- AVERAGE – calculates the average of a range of cells
- MAX – returns the highest value in a range of cells
- MIN – returns the lowest value in a range of cells
- COUNT – counts the number of cells containing numerical data in a range of cells
- CONCATENATE – combines the content of multiple cells into a single cell
- TODAY – returns the current date
- VLOOKUP – searches for a value in a table, and returns a corresponding value in the same row
- PMT – calculates the periodic payment for a loan with a constant interest rate and fixed term.