Syntax

LOGEST(known_data_y, [known_data_x], [b], [verbose])

Arguments

The printed syntax lists 3 argument(s), in order:

  • known_data_y
  • nown_data_ optional
  • erbos optional

“optional” marks an argument Google prints in square brackets; “repeatable” marks one Google prints with “…”.

Description from Google Docs Editors Help

“Given partial data about an exponential growth curve, calculates various parameters about the best fit ideal exponential growth curve.”

Google’s help article for LOGEST →

Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), record record 489 of 516, data fetched 28 September 2026. Data month: September 2026.