+ Reply to Thread
Results 1 to 4 of 4

Explain a function

  1. #1
    Registered User
    Join Date
    08-31-2018
    Location
    england
    MS-Off Ver
    ? on my mac ?
    Posts
    1

    Explain a function

    Hi All

    Im new to excel and have been trying to decipher the function

    =INDIRECT(ADDRESS($A5,2,,,CONCAT("Top Hat (",H$1,")")))

    many thanks

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,904

    Re: Explain a function

    You could try using Evaluate on the formula ribbon which will go through the function one step at a time. The portion of the function which is underlined shows what will be evaluated next.

    Alternatively highlight sub-parts of the function and hit F9 to get them to evaluate.
    Martin

    If my solution has saved you time and/or money, please consider donating to Cancer Research UK or your local equivalent.

    https://www.cancerresearchuk.org/

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    11,086

    Re: Explain a function

    In addition, I find it useful to refer to the help files for the functions to get a description of each argument/part of the function and what it does: https://support.office.com/en-us/art...6-c6d90033e188

    Overall, it looks like the function takes a sheet/tab name/number/identifier in H1 and a row number in A5 and returns the value from the resulting reference. Is that what you are expecting it to do?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Registered User
    Join Date
    09-12-2018
    Location
    Singapore
    MS-Off Ver
    2016
    Posts
    4

    Re: Explain a function

    Excel INDIRECT Function. The INDIRECT function returns a reference to a range. You can use this function to create a reference that won't change if row or columns are inserted in the worksheet.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1