Basic question about formulas

Posted on 2014-08-20
Last Modified: 2014-08-20
I have a spreadsheet with a cell whose calculation looks like this in the formula bar:


Can someone explain this syntax to me, and where I can find the actual formula (I don't see any worksheets named 'My_Calculations').

Thanks -
Question by:mbizup
    LVL 47

    Accepted Solution


    it is a sheet

    it may be hidden (right-click one of the sheet tabs and choose unhide to see it)

    or it may be veryHidden then you can only unhide it if you have acces to the VBA Project

    (Alt-F11 choose your file develop Microsoft Excel Ojects Click the sheet View Properties window and choose Visible xkSheetVisible

    LVL 61

    Author Closing Comment

    Thank you.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
    Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now