LOG Function in Excel, Google Sheets, Airtable & Notion
LOG(number, base) answers “what power of base gives number?”. LOG(1000, 10) is 3 because 10³ = 1000. The base defaults to 10.
Syntax in each app
| App | Support | Syntax & notes |
|---|---|---|
| Excel | ✔ Built in | LOG(number, [base])Also LN(number) and LOG10(number). |
| Google Sheets | ✔ Built in | LOG(value, [base]) |
| Airtable | ✔ Built in | LOG(number, [base]) |
| Notion | ✔ Built in | log10(number) · log2(number) · ln(number)For any other base, divide natural logs: ln(x) / ln(base). |
| Excel | =LOG(1000, 10) | open excel.new ↗ |
|---|---|---|
| Google Sheets | =LOG(1000, 10) | open sheets.new ↗ |
| Airtable | LOG(1000, 10) | |
| Notion | log10(1000) |
Excel & Sheets use cell ranges. Paste this sample data into cell A1 of a blank sheet, then paste the formula into any empty cell.
Arguments
| Argument | What it means |
|---|---|
number | A positive number. |
[base] optional | The base of the logarithm. Defaults to 10. Must be positive and not 1. |
Examples
| Formula | Result | Why | Copy |
|---|---|---|---|
=LOG(1000) | 3 | Base 10 by default. | |
=LOG(8, 2) | 3 | 2³ = 8. | |
=LN(EXP(1)) | 1 | Natural log uses base e. | |
=LOG(2)/LOG(1+7%) | 10.24 | Years to double money at 7% a year. |
Examples use Excel / Google Sheets syntax unless noted.
How LOG works
Logarithms turn multiplication into addition, so they show up whenever something grows by a percentage: how many periods until an investment doubles (=LOG(2)/LOG(1+rate)), how many halvings until a value drops below a threshold, or putting very skewed data on a readable scale.
Excel, Google Sheets and Airtable share LOG(number, base) with base 10 as the default. Notion has fixed-base functions instead — log10, log2 and ln — and any other base is ln(x) / ln(base), which is exactly what the Notion copy button builds.
Frequently Asked Questions
- How do I calculate a natural log?
- Use
=LN(A2)in Excel or Google Sheets,LOG(A2, EXP(1))in Airtable, orln(prop("x"))in Notion.