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). Click in the 'Column input cell' box (the percentages are in a column) and select cell C4. ![]() 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.Ĥ. Type the different percentages in column A. Select cell B12 and type =D10 (refer to the total profit cell).Ģ. ![]() To create a one variable data table, execute the following steps.ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |