How can a Name in the Name Manager refer to a formula rather than to a range of cells?
I am comfortable using the Name Manager in Excel (2010) but I have not previously come across a Name which refers to anything other than a range of cells. However, I recently opened an old amortization schedule template which I downloaded or received from somewhere/someone many years ago.
Interestingly, in the first row of the schedule, the formula under the heading Beginning Balance is as follows:
That seemed odd because rather than some type of criteria or question as the first argument, it simply displays what appears to be a named cell range. Therefore, I opened the Name Manager and that's when I discovered that rather than defining a range of cells, the name
which seems to be a way of checking that each of the included ranges is populated.
Is that interpretation correct?
1) Is the name "Values_Entered" and its corresponding formula something that is built into Excel or something that was created and defined by the person who built the amortization template?
2) If the former, how does one access it and similar built-in named formulas in Excel?
3) If the latter, how does one go about creating additional named formulas in Excel?