Statistical

LOGEST Function in Excel

Returns the parameters of an exponential trend using least squares.

Syntax

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

Arguments

  • known_y's (required): Dependent values
  • known_x's (optional): Independent values
  • const (optional): TRUE to calculate constant
  • stats (optional): TRUE to return additional statistics

Examples

  • =LOGEST(B1:B10, A1:A10) - Exponential regression - Result: Growth parameters

LOGEST for data analysis

  • Confirm whether you need entire columns, filtered subsets, or distinct values.
  • Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
  • Pivot tables complement single-cell statistical formulas for exploration.

Common errors

  • Y values must be positive

Use cases

  • Exponential growth
  • Population modeling
  • Compound growth

Frequently asked questions

  • What is LOGEST used for? LOGEST calculates exponential regression parameters, fitting the equation y = b*m^x to your data. It's ideal for modeling exponential growth like population, compound interest, or viral spread where values multiply rather than add over time.
  • When should I use LOGEST vs LINEST? Use LINEST for linear relationships (constant rate of change). Use LOGEST when data grows/decays by a percentage (exponential). If plotting your data shows a curve that could be straightened by using log scale, LOGEST is appropriate.
  • Why does LOGEST require positive Y values? LOGEST fits an exponential curve (y = b*m^x), which mathematically cannot produce negative or zero values. If your data contains zeros or negatives, consider adding a constant to shift values positive, or use LINEST on log-transformed data.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.