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
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
Arguments
| Argument | Required? | What it does |
|---|---|---|
| known_y's | Yes | The y values; all must be greater than 0. |
| known_x's | No | One or more columns of x values. If left out, 1, 2, 3 … is used. |
| const | No | TRUE or omitted calculates b; FALSE forces b to 1. |
| stats | No | TRUE 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.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Month | Subscribers | m (growth factor) | b (constant) | |
| 2 | 1 | 1000 | 1.1018 | 915.82 | |
| 3 | 2 | 1120 | |||
| 4 | 3 | 1230 | Monthly growth | 0.1018 | |
| 5 | 4 | 1350 | |||
| 6 | 5 | 1490 | |||
| 7 | 6 | 1630 |
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

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.