Spreadsheet formulas explained, side by side

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

AppSupportSyntax & notes
Excel✔ Built inLOG(number, [base])
Also LN(number) and LOG10(number).
Google Sheets✔ Built inLOG(value, [base])
Airtable✔ Built inLOG(number, [base])
Notion✔ Built inlog10(number) · log2(number) · ln(number)
For any other base, divide natural logs: ln(x) / ln(base).
Try LOG with your own values
Use 2.718281828 for a natural log
Result (as Excel & Google Sheets return it)
3
Your formula, ready to paste
Excel=LOG(1000, 10) open excel.new ↗
Google Sheets=LOG(1000, 10) open sheets.new ↗
AirtableLOG(1000, 10)
Notionlog10(1000)

Arguments

ArgumentWhat it means
numberA positive number.
[base] optionalThe base of the logarithm. Defaults to 10. Must be positive and not 1.

Examples

FormulaResultWhyCopy
=LOG(1000)3Base 10 by default.
=LOG(8, 2)32³ = 8.
=LN(EXP(1))1Natural log uses base e.
=LOG(2)/LOG(1+7%)10.24Years 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, or ln(prop("x")) in Notion.

Part of the Math & Rounding functions. Results in the tester follow Excel and Google Sheets behaviour; always double-check important work in your own file.