Math & Rounding Functions
Sums, products, rounding, remainders, powers and roots. Each function below has a side-by-side syntax table for Excel, Google Sheets, Airtable and Notion, a live tester, and one-click copy buttons.
| Function | What it does | Excel | Google Sheets | Airtable | Notion |
|---|---|---|---|---|---|
| SUM | Add up numbers or a range of cells | ✔ | ✔ | ✔ | ✔ |
| PRODUCT | Multiply numbers together | ✔ | ✔ | ≈ | ≈ |
| ROUND | Round a number to a set number of decimals | ✔ | ✔ | ✔ | ≈ |
| ROUNDUP | Round away from zero | ✔ | ✔ | ✔ | ≈ |
| ROUNDDOWN | Round toward zero (truncate) | ✔ | ✔ | ✔ | ≈ |
| INT | Round down to the nearest whole number | ✔ | ✔ | ✔ | ✔ |
| MOD | Remainder after division | ✔ | ✔ | ✔ | ✔ |
| ABS | Absolute value (remove the minus sign) | ✔ | ✔ | ✔ | ✔ |
| POWER | Raise a number to a power | ✔ | ✔ | ✔ | ✔ |
| SQRT | Square root of a number | ✔ | ✔ | ✔ | ✔ |
| CEILING | Round up to the nearest multiple | ✔ | ✔ | ✔ | ≈ |
| FLOOR | Round down to the nearest multiple | ✔ | ✔ | ✔ | ≈ |
| LOG | Logarithm to any base | ✔ | ✔ | ✔ | ✔ |
✔ built-in function ≈ works with a workaround formula ✘ not available