{"id":267237,"date":"2024-03-13T20:08:44","date_gmt":"2024-03-13T19:08:44","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=267237"},"modified":"2026-11-17T14:22:17","modified_gmt":"2026-11-17T13:22:17","slug":"fonction-growth-excel","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/excel-functions\/excel-growth-function\/","title":{"rendered":"Fonction GROWTH d'Excel : comment l'utiliser et exemples"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Let\u2019s say you\u2019ve introduced new products or services to your business that have started doing very well. Not only do your revenue figures increase every month, but the \u201cincrease\u201d itself is also growing. If you want to predict your future expenses, looking at the figures for previous years, you might notice that they\u2019ve started growing exponentially as well.<\/p>\n<p>Whichever the case, you can use Excel\u2019s GROWTH function to obtain an estimate for the next month or year. If your figures show linear growth, you should use the TREND function instead.<\/p>\n<p>In this article, you will learn what the GROWTH function in Excel is and how to use it to predict future values based on existing ones. In addition to the known values for the dependent variable, you can also include values for one or more independent variables.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-is-excel-s-growth-function&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>What is Excel&#8217;s GROWTH function?<\/h2>\n<p>The GROWTH function predicts future values based on the assumption of exponential growth.<\/p>\n<p>To calculate this, the Excel GROWTH function requires values you already have for the dependent variable (known_y&#8217;s).<\/p>\n<p>As for the optional values, these include those corresponding to the independent variable which you may or may not have (known_x&#8217;s), and those for which you\u2019d like to find new values (new_x&#8217;s). The last is a logical value to determine the constant (const).<\/p>\n<p>If your values show linear growth, you can use the TREND function to estimate future values. The same straight-line idea is behind <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/linear-regression-google-sheets\/\">linear regression in Google Sheets<\/a>.<\/p>\n<h3>GROWTH function syntax<\/h3>\n<p>The syntax for Excel&#8217;s GROWTH function is shown below:<\/p>\n<p><code>=GROWTH(known_y's, [known_x's], [new_x's], [const])<\/code><\/p>\n<ul>\n<li><strong>known_y&#8217;s (required):<\/strong> These are the values you already have for the dependent variable. If any of the values in this array is 0 or negative, you will get the \u201c#NUM!\u201d value error.<\/li>\n<li><strong>known_x&#8217;s (optional):<\/strong> An optional set of values for the independent variable, which you may already have. If you don\u2019t, you can omit this parameter.<\/li>\n<li><strong>new_x&#8217;s (optional):<\/strong> The new values of the independent variable (x), for which you want to find the values of the dependent variable (y). If this parameter is omitted, it is assumed to be the same as the known_x\u2019s. If both known_x\u2019s and new_x\u2019s are omitted, they are assumed to be the array {1,2,3,&#8230;}.<\/li>\n<li><strong>const (optional):<\/strong> A logical value that determines whether or not the constant (b) will be calculated:\n<ul>\n<li><strong>If TRUE or omitted,<\/strong> b will be calculated.<\/li>\n<li><strong>If FALSE,<\/strong> b will be equal to 1. The formula is then adjusted to y = m^x.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>To learn more about using this function with multiple variables in the form of complex arrays and vectors, visit <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/growth-function-541a91dc-3d5e-437d-b156-21324e68b80d\" rel=\"noreferrer noopener\" target=\"_blank\">Microsoft\u2019s support page on this function<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-use-excel-s-growth-function&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to use Excel&#8217;s GROWTH function?<\/h2>\n<p>The GROWTH function can return a value or an array of values. This is how you can use the GROWTH function in your worksheet to predict a single value and to predict an array of values.<\/p>\n<h3>Use GROWTH to predict a value<\/h3>\n<p>In the spreadsheet shown below, we have the values for monthly revenue for the last eleven months. I will use the GROWTH function to estimate the expected revenue for the next month, assuming exponential growth.<\/p>\n<p>One column contains the values for the monthly revenue, known_y\u2019s, and a second column contains the values for the month number known_x\u2019s.<\/p>\n<p><strong>1.<\/strong> Click on the cell where you want the predicted value for revenue to appear. Here, B13.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-growth-function-select-cell-for-new-y-value.webp&#8221; alt=&#8221;Excel growth function \u2014 month numbers 1 to 12 and monthly revenue in euros, with empty cell B13 selected for the month 12 prediction&#8221; title_text=&#8221;Month numbers 1 to 12 and monthly revenue in euros, with empty cell B13 selected for the month 12 prediction&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> Type in the formula (see GROWTH function syntax above) and select the known_y\u2019s, that is all cells containing the revenue values. Then, add a semicolon to trigger the next argument. Here, &#8220;B2:B12;&#8221;. The screenshots use semicolons to separate arguments. If your version of Excel uses commas, type a comma wherever these steps say semicolon.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-growth-function-select-known-y-values.webp&#8221; alt=&#8221;Excel growth function \u2014 =GROWTH(B2:B12 typed in B13 with the revenue range highlighted and the argument tooltip below&#8221; title_text=&#8221;=GROWTH(B2:B12 typed in B13 with the revenue range highlighted and the argument tooltip below&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> After the semicolon, include the range for known_x\u2019s and add a semicolon before entering the next argument.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-growth-function-select-known-x-values.webp&#8221; alt=&#8221;Excel growth formula \u2014 =GROWTH(B2:B12;A2:A12 in the formula bar with the month numbers in column A highlighted as known_x&#8217;s&#8221; title_text=&#8221;=GROWTH(B2:B12;A2:A12 in the formula bar with the month numbers in column A highlighted as known_x&#8217;s&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4.<\/strong> Select the cell with the new_x\u2019s (here, \u201cA13\u201d) and add a semicolon to trigger the options for the const argument.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-growth-function-select-new-x-value.webp&#8221; alt=&#8221;Excel growth formula \u2014 =GROWTH(B2:B12;A2:A12;A13 with cell A13, month 12, selected as new_x&#8217;s&#8221; title_text=&#8221;=GROWTH(B2:B12;A2:A12;A13 with cell A13, month 12, selected as new_x&#8217;s&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5.<\/strong> The values for const are \u201cFALSE &#8211; b is set equal to 1\u201d or \u201cTRUE &#8211; b is calculated normally\u201d. If you choose \u201cTRUE\u201d or leave it empty, the value for \u201cb\u201d is calculated. If you choose \u201cFALSE\u201d, it will be set equal to 1.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-growth-function-select-const-value.webp&#8221; alt=&#8221;Excel growth function \u2014 const options list showing FALSE, b is set equal to 1, and TRUE, b is calculated normally&#8221; title_text=&#8221;Const options list showing FALSE, b is set equal to 1, and TRUE, b is calculated normally&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6.<\/strong> Finish the formula by adding the closing parenthesis and press \u201cEnter\u201d.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-growth-function-press-enter.webp&#8221; alt=&#8221;Excel growth function \u2014 finished formula =GROWTH(B2:B12;A2:A12;A13;TRUE) in cell B13 before pressing Enter&#8221; title_text=&#8221;Finished formula =GROWTH(B2:B12;A2:A12;A13;TRUE) in cell B13 before pressing Enter&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>7.<\/strong> Excel will now show the predicted value for the next month in the cell you initially selected.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-growth-function-predicted-value.webp&#8221; alt=&#8221;Excel growth function \u2014 B13 returns a predicted revenue of 1.491.620,76 euros for month 12&#8243; title_text=&#8221;B13 returns a predicted revenue of 1.491.620,76 euros for month 12&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Use GROWTH to predict an array of values<\/h3>\n<p>Let\u2019s say your spreadsheet contains values for yearly expenses over the last six years. Use the GROWTH function to estimate the expenses for the next three years, assuming exponential growth.<\/p>\n<p>In the first column, you can include the years, known_x\u2019s, and the second column should contain the values for the yearly expenses, known_y\u2019s. To predict three new values for known_y\u2019s, you\u2019ll need to use the function as an array formula.<\/p>\n<p><strong>1.<\/strong> Select the cells where you want the new values for expenses, new_x\u2019s, to show.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-growth-function-select-cells-for-new-array.webp&#8221; alt=&#8221;Excel growth function array \u2014 yearly expenses for 2016 to 2021 with cells B8 to B10 selected for 2022 to 2024&#8243; title_text=&#8221;Yearly expenses for 2016 to 2021 with cells B8 to B10 selected for 2022 to 2024&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> Click on the formula bar and type in the GROWTH function. Select the known_y\u2019s and add a semicolon to trigger the next argument.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-growth-function-select-known-y-values-2.webp&#8221; alt=&#8221;Excel growth function array \u2014 =GROWTH(B2:B7 typed with the 2016 to 2021 expenses highlighted&#8221; title_text=&#8221;=GROWTH(B2:B7 typed with the 2016 to 2021 expenses highlighted&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> Select the known_x\u2019s and add a semicolon to trigger the next argument.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-growth-function-select-known-x-values-2.webp&#8221; alt=&#8221;Excel growth formula array \u2014 =GROWTH(B2:B7;A2:A7 with the years 2016 to 2021 highlighted as known_x&#8217;s&#8221; title_text=&#8221;=GROWTH(B2:B7;A2:A7 with the years 2016 to 2021 highlighted as known_x&#8217;s&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4.<\/strong> Select the new_x\u2019s and add a semicolon to see the options for const.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-growth-function-select-new-x-values.webp&#8221; alt=&#8221;Excel growth formula array \u2014 =GROWTH(B2:B7;A2:A7;A8:A10 with the years 2022 to 2024 selected as new_x&#8217;s&#8221; title_text=&#8221;=GROWTH(B2:B7;A2:A7;A8:A10 with the years 2022 to 2024 selected as new_x&#8217;s&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5.<\/strong> The values for const are \u201cFALSE &#8211; b is set equal to 1\u201d or \u201cTRUE &#8211; b is calculated normally\u201d. If you choose \u201cTRUE\u201d or leave it empty, the value for \u201cb\u201d is calculated. If you choose \u201cFALSE\u201d, it will be set equal to 1.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-growth-function-select-const-value-2.webp&#8221; alt=&#8221;Excel growth function array \u2014 const options list with FALSE and TRUE after the new_x&#8217;s range A8:A10&#8243; title_text=&#8221;Const options list with FALSE and TRUE after the new_x&#8217;s range A8:A10&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6.<\/strong> After adding the final parenthesis, remember to press Ctrl + Shift + Enter for the array of values to be returned correctly. In Excel for Microsoft 365 and Excel 2021 or later, you can type the formula in the first cell and press Enter. The results spill into the cells below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-growth-function-press-ctrl-shift-enter.webp&#8221; alt=&#8221;Excel growth function array \u2014 =GROWTH(B2:B7;A2:A7;A8:A10) in the formula bar, ready for Ctrl + Shift + Enter&#8221; title_text=&#8221;=GROWTH(B2:B7;A2:A7;A8:A10) in the formula bar, ready for Ctrl + Shift + Enter&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>7.<\/strong> Excel should now return the predicted values for the next three years in the corresponding cells.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/11\/excel-growth-function-predicted-values.webp&#8221; alt=&#8221;Excel growth function array \u2014 predicted expenses for 2022, 2023 and 2024 returned by the array formula in braces&#8221; title_text=&#8221;Predicted expenses for 2022, 2023 and 2024 returned by the array formula in braces&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;growth-function-vs-growth-rate-formula-i&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>GROWTH function vs growth rate formula in Excel<\/h2>\n<p>The GROWTH function and a growth rate formula answer different questions. GROWTH predicts future values, such as next month&#8217;s revenue. A growth rate formula tells you how much a value changed, as a percentage.<\/p>\n<p>To get the growth rate between two periods, subtract the old value from the new one and divide by the old value:<\/p>\n<p><code>=(B3-B2)\/B2<\/code><\/p>\n<p>Format the cell as a percentage to read the result. Our guide to <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/calculate-year-over-year-growth\/\">calculating year-over-year growth<\/a> walks through this formula with an example.<\/p>\n<p>For the average yearly growth over several years, use the compound annual growth rate (CAGR):<\/p>\n<p><code>=(end_value\/start_value)^(1\/years)-1<\/code><\/p>\n<p>Excel&#8217;s RRI function gives the same result with =RRI(years, start_value, end_value). The <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/cagr-formula-google-sheets\/\">CAGR formula guide<\/a> uses Google Sheets, but the formula works the same way in Excel.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;conclusion&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion<\/h2>\n<p>As you have seen, Excel\u2019s GROWTH function is useful if you need a future estimate and the values you already have show exponential growth. For linear growth, the TREND function is more appropriate. To check which pattern your figures follow, start with a <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/trend-analysis\/\">trend analysis<\/a>.<\/p>\n<p>You now know how to use the GROWTH function to predict both a single future value and an array of values based on known values for two variables. In the first example, the function was used to calculate the predicted value for revenue in the next month. In the second, the function was used to calculate the predicted expenses for the next three years.<\/p>\n<p>If your revenue figures live in several spreadsheets, <a href=\"https:\/\/www.sheetgo.com\/automations\/\">Sheetgo<\/a>, an AI-powered data automation platform, can pull them into one file on a schedule. Your GROWTH forecasts then run on current data that is ready for AI. To build the full forecast, read our guide to <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/revenue-forecasting\/\">revenue forecasting<\/a>.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>La fonction GROWTH d'Excel renvoie la croissance exponentielle pr\u00e9vue pour vos donn\u00e9es. Voici comment utiliser la fonction GROWTH \u00e9tape par \u00e9tape, avec des exemples.<\/p>","protected":false},"author":2,"featured_media":267252,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[65],"tags":[],"class_list":["post-267237","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-functions"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/267237","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=267237"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/267237\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/267252"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=267237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=267237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=267237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}