{"id":264406,"date":"2024-03-13T20:08:32","date_gmt":"2024-03-13T19:08:32","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=264406"},"modified":"2026-11-16T15:49:06","modified_gmt":"2026-11-16T14:49:06","slug":"analyse-de-simulation-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-features\/what-if-analysis-google-sheets\/","title":{"rendered":"Comment r\u00e9aliser une analyse de simulation dans Google Sheets"},"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>Google Sheets has no built-in what-if analysis tool like Excel. However, this doesn\u2019t mean you can\u2019t perform this type of analysis in Google Sheets. Using a <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/top-5-google-sheets-add-ons-for-finance\/\">free add-on<\/a> like Goal Seek, you can carry out what-if analyses to explore and anticipate the consequences of possible future changes. If you are looking for the IF function instead, see this guide to <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/google-sheets-if-functions\/\">IF functions in Google Sheets<\/a>.<\/p>\n<p>In this article, you will learn the difference between what-if and sensitivity analyses and how to use Google Sheets\u2019 Goal Seek add-on to run what-if analyses on multiple scenarios. To learn more about the Goal Seek add-on, check out our article on <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/goal-seek-google-sheets\/\">how to use goal seek in Google Sheets<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;whats-the-difference-between-what-if-and&#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\u2019s the difference between what-if and sensitivity analysis?<\/h2>\n<p>In what-if analysis, various situations or \u201cscenarios\u201d are contemplated through the manipulation of variables. Among others, there are two very popular types of what-if analysis: scenario and sensitivity analysis.<\/p>\n<p>In sensitivity analysis, the focus is on the effects of changes to one specific variable; this type of analysis explains how variables (dependent) are affected based on changes made in another variable (independent). In scenario analysis, the focus is on the effects of changes to multiple variables; here, the different scenarios correspond to these changing variables. For example, a worst-case scenario could involve higher-than-average costs and minimum sales.<\/p>\n<p>As you can see, both types of what-if analysis can be very valuable, allowing you to prepare for change or take calculated risks. In the next section, you will learn how to carry out what-if analyses in Google Sheets.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-if-analysis-with-goal-seek-in-googl&#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-if analysis with Goal Seek in Google Sheets<\/h2>\n<p>By setting up different scenarios in your spreadsheet, you can use Goal Seek for what-if analysis. Whether you carry out sensitivity or scenario analysis will depend on how many variables you manipulate and to what extent you test individual ones.<\/p>\n<p>Follow the steps below to install the Goal Seek add-on for Google Sheets, set up various scenarios, and use Goal Seek to modify multiple variables.<\/p>\n<h3>Install the Goal Seek add-on in Google Sheets<\/h3>\n<p>Like with most Google products and features, you simply need a Google account and a few minutes. Follow the steps below to find and install Goal Seek in Google Sheets.<\/p>\n<p><strong>1.<\/strong> Open Google Sheets and go to Extensions &gt; Add-ons &gt; Get add-ons.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-get-add-ons.webp&#8221; alt=&#8221;What-if analysis in Google Sheets \u2014 Extensions menu open at Add-ons with Get add-ons&#8221; title_text=&#8221;Extensions menu open at Add-ons with Get add-ons&#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> In the Google Workspace Marketplace, search for Goal Seek, click on the add-on, and then \u201cContinue.\u201d<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-goal-seek-add-on.webp&#8221; alt=&#8221;Goal Seek add-on for Google Sheets \u2014 Google Workspace Marketplace search results for Goal Seek&#8221; title_text=&#8221;Google Workspace Marketplace search results for Goal Seek&#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> You will see a pop-up asking you to grant Goal Seek permission to access your account. Click \u201cAllow\u201d to finish installing the add-on.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-allow-access.webp&#8221; alt=&#8221;Goal Seek add-on for Google Sheets \u2014 permission request with the Cancel and Allow buttons&#8221; title_text=&#8221;Permission request with the Cancel and Allow buttons&#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> Once the add-on is successfully installed, you\u2019ll see a confirmation message like the one below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-add-on-installed.webp&#8221; alt=&#8221;Goal Seek add-on for Google Sheets \u2014 Goal Seek has been installed message pointing to Add-ons&#8221; title_text=&#8221;Goal Seek has been installed message pointing to Add-ons&#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<h3>Set up what-if scenarios<\/h3>\n<p>In the example spreadsheet below, you can see three copies of the initial dataset. Here, the goal is to reach profits of $20000 and to analyze different scenarios.<\/p>\n<p>In the first, you\u2019ll see the effects of changing the selling price; in the second, the consequences of changing the number of units sold; and, in the third, the effects of changing the unit cost.<\/p>\n<p>If you want to compare a base, a best, and a worst case side by side, our guide to <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/scenario-analysis\/\">scenario analysis<\/a> shows how to set them up.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-what-if-scenarios.webp&#8221; alt=&#8221;What-if scenarios in Google Sheets \u2014 initial data and three scenario copies with a profit goal of 20000&#8243; title_text=&#8221;Initial data and three scenario copies with a profit goal of 20000&#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>What-if analysis in Google Sheets with Goal Seek<\/h3>\n<p>You can use Goal Seek to carry out a what-if analysis of multiple scenarios by running it on multiple copies of your data, where you can set your goal and specify which variables to change.<\/p>\n<h4>Goal Seek required parameters<\/h4>\n<p>There are three required parameters in Goal Seek:<\/p>\n<ul>\n<li><strong>Target cell:<\/strong> This is the cell containing the formula that will link other cells together. Goal Seek will ensure that the result obtained from this formula corresponds to the value you set as your target.<\/li>\n<li><strong>Target value:<\/strong> This is the value we want to obtain in our target cell.<\/li>\n<li><strong>Changing cell:<\/strong> This is the cell that Goal Seek can manipulate to reach the target value in the target cell.<\/li>\n<\/ul>\n<h4>Goal Seek optional parameters<\/h4>\n<p>You can also configure some optional parameters in Goal Seek:<\/p>\n<ul>\n<li><strong>Maximum iterations:<\/strong> the default value is 200. You can increase this number, so that Goal Seek makes more attempts to find a solution, but this will also depend on the time limit you set.<\/li>\n<li><strong>Tolerance:<\/strong> the default value is 0.0001. You can increase this number if your solution doesn\u2019t need to be this precise.<\/li>\n<li><strong>Maximum time limit:<\/strong> the default value is 120 seconds. You can increase this number for more complex calculations. Calculations will stop when this limit is reached, regardless of the \u201cMax Iterations\u201d setting.<\/li>\n<\/ul>\n<p><strong>1.<\/strong> Go to Extensions &gt; Goal Seek &gt; Open.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-open-goal-seek.webp&#8221; alt=&#8221;What-if analysis in Google Sheets \u2014 Extensions menu open at Goal Seek with Open&#8221; title_text=&#8221;Extensions menu open at Goal Seek with Open&#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> You will see the Goal Seek sidebar on the right of your spreadsheet, including \u201cSettings\u201d, \u201cSolve Status\u201d, and \u201cHistory\u201d.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-goal-seek-sidebar.webp&#8221; alt=&#8221;What-if analysis in Google Sheets \u2014 empty Goal Seek sidebar with Settings, Solve Status and History&#8221; title_text=&#8221;Empty Goal Seek sidebar with Settings, Solve Status and History&#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> Click on the cell containing the profit formula, then click on the grid icon beside \u201cSet Cell\u201d in the sidebar. If you place your cursor over the grid icon, you will see the text \u201cCapture selected cell\u201d, as in the screenshot below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-set-cell.webp&#8221; alt=&#8221;What-if analysis in Google Sheets \u2014 profit cell B20 selected and Capture selected cell next to Set Cell&#8221; title_text=&#8221;Profit cell B20 selected and Capture selected cell next to Set Cell&#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> Next, type in the \u201cTarget value\u201d for the \u201cSet Cell\u201d. Here, \u201c20000\u201d.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-target-value.webp&#8221; alt=&#8221;What-if analysis in Google Sheets \u2014 20000 typed in the To Value box of the Goal Seek sidebar&#8221; title_text=&#8221;20000 typed in the To Value box of the Goal Seek sidebar&#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> Click on the cell containing the value you want Goal Seek to change, then click on the grid icon beside \u201cBy Changing Cell\u201d in the sidebar. Here, the selling price for Scenario 1, cell B14.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-by-changing-cell.webp&#8221; alt=&#8221;What-if analysis in Google Sheets \u2014 selling price cell B14 captured as the By Changing Cell&#8221; title_text=&#8221;Selling price cell B14 captured as the By Changing Cell&#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> To change the number of iterations, the tolerance, and\/or the time limit, click on \u201cOptions\u201d. Here, I will use the default values.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-options.webp&#8221; alt=&#8221;What-if analysis in Google Sheets \u2014 Options open with 200 iterations, 0.0001 tolerance and 120 seconds&#8221; title_text=&#8221;Options open with 200 iterations, 0.0001 tolerance and 120 seconds&#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> Once everything is ready, click \u201cSolve.\u201d With the default options used above, it will take a maximum of two minutes to calculate the solution. If Goal Seek cannot find a solution, try increasing the tolerance or the time limit and number of iterations.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-solve.webp&#8221; alt=&#8221;What-if analysis in Google Sheets \u2014 Set Cell, To Value and By Changing Cell filled in above the Solve button&#8221; title_text=&#8221;Set Cell, To Value and By Changing Cell filled in above the Solve button&#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>8.<\/strong> When Goal Seek finds a solution, you will see a pop-up like the one below. You can see the solution directly in the cell or the \u201cSolve Status\u201d at the bottom of the sidebar.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-goal-seek-complete.webp&#8221; alt=&#8221;What-if analysis in Google Sheets \u2014 Goal Seek Complete pop-up with the selling price at 5.41 and profit at 20000&#8243; title_text=&#8221;Goal Seek Complete pop-up with the selling price at 5.41 and profit at 20000&#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>9.<\/strong> Next, let&#8217;s configure the settings for Scenario 2. First, select the \u201cSet Cell\u201d and the \u201cTarget Value\u201d. Here, the \u201cSet Cell\u201d contains the profit formula in cell E20, and the target value is shown in \u201cTo Value\u201d, i.e. 20000.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-scenario-2-target.webp&#8221; alt=&#8221;What-if analysis in Google Sheets \u2014 Scenario 2 profit cell E20 set with 20000 in To Value&#8221; title_text=&#8221;Scenario 2 profit cell E20 set with 20000 in To Value&#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>10.<\/strong> Once you have set both values, click on the cell with the changing value. Click \u201cSolve\u201d when you\u2019re happy with the settings.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-scenario-2-changing.webp&#8221; alt=&#8221;What-if analysis in Google Sheets \u2014 Scenario 2 units sold cell E15 captured as the changing cell&#8221; title_text=&#8221;Scenario 2 units sold cell E15 captured as the changing cell&#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>11.<\/strong> You will see the \u201cGoal Seek Complete\u201d pop-up again.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-scenario-2-complete.webp&#8221; alt=&#8221;What-if analysis in Google Sheets \u2014 Goal Seek Complete pop-up for Scenario 2 with units sold changed&#8221; title_text=&#8221;Goal Seek Complete pop-up for Scenario 2 with units sold changed&#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>12.<\/strong> Finally, configure the settings for Scenario 3, following the same steps as before, and click \u201cSolve\u201d to finish.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-scenario-3-settings.webp&#8221; alt=&#8221;What-if analysis in Google Sheets \u2014 Scenario 3 settings with profit cell H20 and unit cost cell H16&#8243; title_text=&#8221;Scenario 3 settings with profit cell H20 and unit cost cell H16&#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>13.<\/strong> That\u2019s it. The solution for Scenario 3 is available, as shown below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-scenario-3-complete.png&#8221; alt=&#8221;What-if analysis in Google Sheets \u2014 Goal Seek Complete pop-up for Scenario 3 with unit cost at 0.88&#8243; title_text=&#8221;Goal Seek Complete pop-up for Scenario 3 with unit cost at 0.88&#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>14.<\/strong> You should see the results obtained with Goal Seek for all three scenarios; the changing cells have a green background, and the target cells have a red one.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/what-if-analysis-google-sheets-scenario-results.png&#8221; alt=&#8221;What-if analysis in Google Sheets \u2014 three scenario results with changing cells in green and profit cells in red&#8221; title_text=&#8221;Three scenario results with changing cells in green and profit cells in red&#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;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>You can perform what-if analysis directly in Google Sheets using Goal Seek. You can set up different scenarios with different goals and choose any variable you want as the changing cell. As Goal Seek keeps a history of attempts, you can always return to previous solutions.<\/p>\n<p>After reading this article, you know how to install the Goal Seek add-on, set up scenarios in Sheets, and analyze them using Goal Seek. To learn more about Goal Seek, check out <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/goal-seek-google-sheets\/\">how to use goal seek in Google Sheets<\/a>.<\/p>\n<p>For statistical tools such as regression, try the <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/how-to-use-xlminer-analysis-toolpak-add-on-for-google-sheets\/\">XLMiner Analysis ToolPak add-on<\/a>. To check your scenarios against real results, read how to <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-processes\/budget-vs-actual-how-to-find-and-analyze-variances\/\">find and analyze budget vs. actual variances<\/a>, or start from a <a href=\"https:\/\/www.sheetgo.com\/blog\/finance-templates\/profit-and-loss-statement-template\/\">profit and loss statement template<\/a>.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Apprenez \u00e0 r\u00e9aliser une analyse de simulation dans Google Sheets avec le module compl\u00e9mentaire gratuit Goal Seek, et ce qui la distingue de l'analyse de sensibilit\u00e9.<\/p>","protected":false},"author":2,"featured_media":264426,"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":[37],"tags":[],"class_list":["post-264406","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/264406","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=264406"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/264406\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/264426"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=264406"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=264406"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=264406"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}