Forum Discussion
davidcaijinhang
Feb 04, 2021Copper Contributor
Fullstops in a formula
Hi friends out there, May I ask a quick excel question? When I click on a excel cell in a workbook, I see in the formula "R24*(1+Input.Assumpt.OpEx.Growth)" Do you know what the full stops mean? A...
- Feb 04, 2021
Input.Assumpt.OpEx.Growth is probably a defined name that either refers to a cell, or to a value or formula.
You can create such a name by clicking Define Name in the Defined Names group of the Formulas tab of the ribbon:
Defined names can be used to make it easier to understand what a formula does. A formula such as
=Price+Tax
is clearer than
=A3+D3
ā
HansVogelaar
Feb 04, 2021MVP
Input.Assumpt.OpEx.Growth is probably a defined name that either refers to a cell, or to a value or formula.
You can create such a name by clicking Define Name in the Defined Names group of the Formulas tab of the ribbon:
Defined names can be used to make it easier to understand what a formula does. A formula such as
=Price+Tax
is clearer than
=A3+D3
ā
davidcaijinhang
Feb 04, 2021Copper Contributor
Very helpful! Thanks.