#DATA TABLE WHAT IF ANALYSIS EXCEL 2010 DOWNLOAD#

You will want to populate the 'Row input cell:' field with the variable in your formula table:Д¬lick OK and Excel will populate your table with the results for each of the mileage variables: Then, highlight the cells of your table, including the variables and the formula reference, Then click on the What-If Analysis option in the Data Tools group on the Data tab and choose Data TableвЂ¦:ДЄ dialog box will appear. All you need do is reference the cell using '=' and the cell reference where the formula resides: The next step is to copy the formula into the row (or column if running vertically) where you want the results to be. Notice I have my variables running across the top of the table. Next, I want to set up the table where the results will be posted. I've done so here, with the formula in cell E5: The first step is to create a formula that includes the variable. The variables run (pardon the pun!) from 5 miles per week up to 40 miles, in 5 mile increments: In the single variable scenario, I want to know how many days, hours, and minutes I will have run in a year based on running 8:00 minute miles. I've created a scenario for each, using running as an example.

#DATA TABLE WHAT IF ANALYSIS EXCEL 2010 DOWNLOAD#

If you see a preview, look for the download arrow in the upper right hand corner.Дata Tables can be used to create a table showing the results of a formula with one or two variables. You can download the file here to follow along. Here's how you can use the Data Tables option in the What-If Analysis group in Excel:

Data table what if analysis excel 2010