StatisticsLevel: ExpertAvailable in: Excel 2007+

LOGEST fits y = b·mˣ and returns m (the growth factor) and b. m of 1.05 means 5% growth per period.

Syntax

=LOGEST(known_ys, [known_xs], [const], [stats])

Examples

Example 1

=INDEX(LOGEST(C2:C13, A2:A13), 1) - 1

Average monthly growth rate of sign-ups.

Related functions

GROWTH · LINEST

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.