Formatting cells and ranges
The formula language used in Print Sheet: cell references, arithmetic, common functions, and named ranges.
Basic formulas and functions
The formula bar
Select a cell and type = to enter a formula. The formula bar above the grid shows the full expression; the cell shows the result.
Cell references
- A1 — single cell
- A1:A10 — range of cells
- A1, B1, C1 — multiple non-contiguous cells
Arithmetic
+add,-subtract*multiply,/divide^power%percent
Common functions
| Function | Purpose | | ---------------- | -------------------------- | | SUM | Sum of values | | AVERAGE | Mean of values | | COUNT | Number of numeric values | | MIN, MAX | Lowest and highest value | | IF | Conditional value | | VLOOKUP | Look up a value in a table | | CONCAT | Concatenate text | | LEFT, RIGHT, MID | Substring operations | | LEN | Length of text | | TODAY, NOW | Current date or time |
Named ranges
Use Data -> Named range to give a name to a cell range. References in formulas become more readable: =SUM(revenue) instead of =SUM(B2:B100).