Microsoft Excel Formula bar says Calculations instead of the equation used

Question

For those of you who are Excel experts, I hope this inquiry is simple and quick.
I'm utilizing Microsoft Excel 2013 and the "Retirement Planner" default worksheet. I want to alter some of the current formulas, but each time I click on a cell, the formula appears as follows:

=IFERROR(Calculations!G39,"")

How can I see the formula that was used to determine the value of that cell? This appears to be the syntax:

Calculations!G39

Abstracts the basic equation away.

Answer 1

By right-clicking the Retirement Planner sheet tab and choosing Unhide from the pop-up menu, you can reveal a hidden Calculations page.

A named range is referenced by the formula =Interest in cell G39 of the Calculations sheet.

You may find the formula for Interest in the Name Manager under the Ribbon Formulas tab.

=IF(PlanYear<=PlanYears,(Calculations!F39*BeforeRetirement*InvestmentReturnPreRetirementPercentage)+(Calculations!F39*AfterRetirement*InvestmentReturnPostRetirementPercentage),NA())