Microsoft Excel Formula bar says Calculations instead of the equation used

0 votes

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 by Kithuzzz
• 28,520 points
54 views

1 answer to this question.

0 votes

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())
answered Nov 26, 2022 by narikkadan
• 52,760 points

Related Questions In Others

0 votes
1 answer

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

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

answered Nov 13, 2022 in Others by narikkadan
• 52,760 points
90 views
0 votes
1 answer
0 votes
1 answer

Excel Formula calculating the starting date of a given calendar week

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

answered Dec 10, 2022 in Others by narikkadan
• 52,760 points
78 views
0 votes
1 answer

Hiding the formula bar in Excel for a specific file

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

answered Dec 17, 2022 in Others by narikkadan
• 52,760 points
68 views
0 votes
1 answer

Automate compound annual growth rate (CAGR) calculation

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

answered Oct 7, 2022 in Others by narikkadan
• 52,760 points
274 views
0 votes
1 answer

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

answered Oct 17, 2022 in Others by narikkadan
• 52,760 points
138 views
0 votes
1 answer

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

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

answered Nov 12, 2022 in Others by narikkadan
• 52,760 points
68 views
0 votes
1 answer

Camel case converter in an excel

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

answered Nov 19, 2022 in Others by narikkadan
• 52,760 points
254 views
0 votes
1 answer

MS Excel showing the formula in a cell instead of the resulting value

Make sure that... There's an = sign before the formula There's ...READ MORE

answered Nov 8, 2022 in Others by narikkadan
• 52,760 points
126 views
0 votes
1 answer

What is the application name of Microsoft Excel?

The name and path of Excel can ...READ MORE

answered Nov 5, 2022 in Others by narikkadan
• 52,760 points
88 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP