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.

Nov 26, 2022 in Others 366 views

## 1 answer to this question.

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())`
• 63,700 points

## Text with a dash in the cell but not in the formula bar (Excel)

What you have got here is called ...READ MORE

## In MS Excel what formula can be used to calculate growth when CAGR for the period is already given?

If those are true CAGR's, then just ...READ MORE

## Excel Formula calculating the starting date of a given calendar week

The number of days to take into ...READ MORE

## Hiding the formula bar in Excel for a specific file

No, you cannot. Unfortunately, altering the CustomUI file ...READ MORE

## Automate compound annual growth rate (CAGR) calculation

The following PowerPivot DAX formulas worked for ...READ MORE

## How do you calculate the Quintile for groups of rows in Excel?

Use this formula: =MAX(1,ROUNDUP(10*PERCENTRANK(\$C:\$C,\$C2,4),0)) To divide into whichever many ...READ MORE

## =CONCATENATE() function giving a #VALUE! error (EXCEL 2013)

You can use the following: =A1&","&B1 TEXTJOIN would also ...READ MORE

## Camel case converter in an excel

Try this: =LOWER(LEFT(A1)) & MID(SUBSTITUTE(PROPER(A1),"_","") ...READ MORE