Forum Discussion

davidcaijinhang's avatar
davidcaijinhang
Copper Contributor
Feb 04, 2021
Solved

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...
  • HansVogelaar's avatar
    Feb 04, 2021

    davidcaijinhang 

    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

    ā€ƒ

Resources