{"id":218,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/growth\/"},"modified":"2021-02-13T11:34:19","modified_gmt":"2021-02-13T11:34:19","slug":"growth","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/growth\/","title":{"rendered":"GROWTH"},"content":{"rendered":"

Introduction:<\/b><\/p>\n

In this guide, we will delve into the GROWTH function as utilized in Microsoft Excel and Google Sheets. This function is primarily employed for projecting future values from existing datasets, calculating the exponential growth trend represented by your data points.<\/p>\n

About GROWTH Function:<\/h2>\n

The syntax for the GROWTH function is consistent across both Excel and Google Sheets:<\/p>\n

=GROWTH(known_y's, [known_x's], [new_x's], [const])<\/code><\/pre>\n
    \n
  • known_y’s<\/b>: These are the known y-values in your dataset.<\/li>\n
  • known_x’s<\/b>: Optionally, these are the known x-values. If this argument is omitted, the function uses the default array {1,2,3,…}.<\/li>\n
  • new_x’s<\/b>: These are the new x-values for which you aim to predict corresponding y-values.<\/li>\n
  • const<\/b>: This is a logical value that determines whether the constant b is set to 1. Its default value is FALSE.<\/li>\n<\/ul>\n
    Examples and Usage:<\/h2>\n
    Example 1:<\/b> Predicting Future Sales<\/p>\n
    Consider a dataset of historical sales figures from which you wish to forecast future sales using the GROWTH function:<\/p>\n\n\n\n\n\n
    Month<\/th>\nSales<\/th>\n<\/tr>\n
    January<\/td>\n100<\/td>\n<\/tr>\n
    February<\/td>\n120<\/td>\n<\/tr>\n
    March<\/td>\n150<\/td>\n<\/tr>\n<\/table>\n
    To predict sales for April and May:<\/p>\n
    =GROWTH(B2:B4, A2:A4, {4, 5})<\/code><\/pre>\n
    This formula calculates and returns the predicted sales values for April and May.<\/p>\n
    Example 2:<\/b> Population Growth Projection<\/p>\n
    Imagine a dataset containing population counts over certain years and you wish to forecast future population figures. Here\u2019s how you can apply the GROWTH function:<\/p>\n\n\n\n\n\n
    Year<\/th>\nPopulation<\/th>\n<\/tr>\n
    2010<\/td>\n10000<\/td>\n<\/tr>\n
    2015<\/td>\n15000<\/td>\n<\/tr>\n
    2020<\/td>\n22000<\/td>\n<\/tr>\n<\/table>\n
    To forecast the population for the years 2025 and 2030:<\/p>\n
    =GROWTH(B2:B4, A2:A4, {2025, 2030})<\/code><\/pre>\n
    This formula outputs the projected population figures for 2025 and 2030 based on the previously known data.<\/p>\n
    It is important to note that the GROWTH function is most effective with datasets that exhibit exponential growth patterns. Adequate data points are critical for making reliable forecasts.<\/p>\n
    Having explored the mechanics of the GROWTH function in Excel and Google Sheets, you are now equipped to apply it across various predictive analysis scenarios, leveraging historical data for strategic insights.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Returns values along an exponential trend<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[203],"tags":[],"class_list":["post-218","post","type-post","status-publish","format-standard","hentry","category-statistical"],"acf":[],"yoast_head":"\nExcel GROWTH Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel GROWTH function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/en\/growth\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel GROWTH Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel GROWTH function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/growth\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:34:19+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel GROWTH Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/growth\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/growth\/\",\"name\":\"Excel GROWTH Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:46+00:00\",\"dateModified\":\"2021-02-13T11:34:19+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel GROWTH function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/growth\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/growth\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/growth\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Function Excel\",\"item\":\"https:\/\/functiontranslator.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Statistical\",\"item\":\"https:\/\/functiontranslator.com\/en\/statistical\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"GROWTH\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel GROWTH Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel GROWTH function does. Clear syntax explanation and useful formula examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/en\/growth\/","og_locale":"en_US","og_type":"article","og_title":"Excel GROWTH Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel GROWTH function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/growth\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:34:19+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel GROWTH Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/growth\/","url":"https:\/\/functiontranslator.com\/en\/growth\/","name":"Excel GROWTH Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:46+00:00","dateModified":"2021-02-13T11:34:19+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel GROWTH function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/growth\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/growth\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/growth\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Function Excel","item":"https:\/\/functiontranslator.com\/en\/"},{"@type":"ListItem","position":2,"name":"Statistical","item":"https:\/\/functiontranslator.com\/en\/statistical\/"},{"@type":"ListItem","position":3,"name":"GROWTH"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/comments?post=218"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/218\/revisions"}],"predecessor-version":[{"id":3109,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/218\/revisions\/3109"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}