How to display data table in logixpro8/11/2023 ![]() 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. Therefore, you cannot delete a single result. Note: the formula bar indicates that the cells contain an array formula. 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). ![]() 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.Ĥ. 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 |