![]() AdditionalĪs with almost everything else you can do in Excel, you can take this What-If Analysis feature to some rather elaborate scenarios. Plugin your own numbers and give your little What-If worksheet a spin. Go ahead and change the values in cells B3 and B4. In any case, now you can make projections from two perspectives, income (Growth) and Expenses. =Sales_2018+(Sales_2018*Growth_2019 *Expenses_2019 )Īs I’m sure you can imagine, your What-If’s can be much more elaborate, depending on several factors, including the data you include, your formula-writing skills, and so on. Modify the formula in cell C5 as follows (add *Expenses_2019 at the end of the parenthetical data.).In the New Name dialog box, click in the Name field and type Expenses_2019.Įasy so far, right? All that’s left to do is modify our formula to include the value in cell C4, like this:.Right-click in cell C4 and select Define Name from the pop-up menu.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |