Fullstops in a formula

[davidcaijinhang]

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? And how do I usually use them when I write formula? Thanks.

[#2]

@davidcaijinhang I suspect the the "Input.Assumpt.OpEx.Growth" part is a Named Range, probably used to refer to a cell reference that should remain static (i.e. an absolute reference), similar to using a reference like $B$10. The points are allowed when you define a Named Range but have no particular meaning.

[#3 · Accepted solution]

@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

 

[#4]

Thanks, may I ask how you use the "points" to define a Named Range? I've familiar with relative reference and absolute reference but don't have any experience using "points" to define a Named Range.

[#5]

Very helpful! Thanks.