To delete the results, select the range B13:D17 and press Delete. Therefore, you cannot delete a single result. Note: the formula bar indicates that the cells contain an array formula. Together with the formula in cell A12, Excel now knows that it should replace cell D7 with $50 and cell C4 with 60% to calculate the total profit, replace cell D7 with $50 and cell C4 with 70% to calculate the total profit, etc.Ĭonclusion: if you sell 60% for the highest price, at a unit profit of $50, you obtain a total profit of $3800, if you sell 80% for the highest price, at a unit profit of $60, you obtain a total profit of $5200, etc. We select cell C4 because the percentages refer to cell C4. We select cell D7 because the unit profits refer to cell D7. Click in the 'Column input cell' box (the percentages are in a column) and select cell C4. Click in the 'Row input cell' box (the unit profits are in a row) and select cell D7.Ĩ. On the Data tab, in the Forecast group, click What-If Analysis.ħ. We are going to calculate the total profit for the different combinations of 'unit profit (highest price)' and '% sold for the highest price'.ĥ. Type the different percentages in column A. Type the different unit profits (highest price) in row 12.ģ. Select cell A12 and type =D10 (refer to the total profit cell).Ģ. To create a two variable data table, execute the following steps.ġ. To delete the results, select the range B13:B17 and press Delete. Note: this is a one variable data table so we leave the Row input cell blank.Ĭonclusion: if you sell 60% for the highest price, you obtain a total profit of $3800, if you sell 70% for the highest price, you obtain a total profit of $4100, etc. Together with the formula in cell B12, Excel now knows that it should replace cell C4 with 60% to calculate the total profit, replace cell C4 with 70% to calculate the total profit, etc. We select cell C4 because the percentages refer to cell C4 (% sold for the highest price). On the Data tab, in the Forecast group, click What-If Analysis.Ħ. We are going to calculate the total profit if you sell 60% for the highest price, 70% for the highest price, etc.Ĥ. Get rid of complex spreadsheets thanks to drag-and-drop navigations, customization options, and easily navigated fields. Create much more than a traditional spreadsheet with Retable's smart and easy-to-use interface. Type the different percentages in column A. Say goodbye to tedious manual work and hello to efficient data management with the best online spreadsheet generator. Select cell B12 and type =D10 (refer to the total profit cell).Ģ. In the Settings, make sure that is the option "Split table in multiple pages" is checked.To create a one variable data table, execute the following steps.ġ. Another option is to display your table in landscape mode.īy default, when a table is too long, it will be cropped by the page. You can activate those options in the Settings. However, sometimes, your text might not fit in a column. In most case, this should be the best option.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |