LOGEST Function

Returns the parameters of an exponential (compound-growth) curve fitted to data.

Category

Statistical

Available in

All versions; spills in Microsoft 365 and Excel 2021+ (older versions: select the output cells and press Ctrl+Shift+Enter)

Returns

An array

Want to practice LOGEST in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

LOGEST fits y = b × mˣ and returns m and b. m is the growth factor per step of x: 1.08 means +8% each period, 0.95 means −5%.

Like LINEST, it can take several x columns and return a statistics block (stats = TRUE). The statistics describe the straight-line fit of ln(y), which is how the curve is calculated.

Syntax

=LOGEST(known_y's, [known_x's], [const], [stats])

Arguments

ArgumentRequired?What it does
known_y'sYesThe y values; all must be greater than 0.
known_x'sNoOne or more columns of x values. If left out, 1, 2, 3 … is used.
constNoTRUE or omitted calculates b; FALSE forces b to 1.
statsNoTRUE returns additional regression statistics.

Examples

Example 1 — Monthly growth rate

LOGEST in D2 spills m and b; subtract 1 from m for the growth rate.

D2fx=LOGEST(B2:B7,A2:A7)
ABCDE
1MonthSubscribersm (growth factor)b (constant)
2110001.1018915.82
321120
431230Monthly growth0.1018
541350
651490
761630
=LOGEST(B2:B7,A2:A7) Explain

About 10.2% growth a month. b × m⁷ = 915.82 × 1.1018⁷ ≈ 1,805 — the same as GROWTH for month 7.

Common mistakes

  • #NUM! A known y is zero or negative.
  • #SPILL! The cell to the right isn't empty.
  • Reversed order with several x columns. As with LINEST, factors are listed from the last x column to the first, with b last.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.