+ 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,967

    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

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

    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)

Similar Threads

  1. Help--Explain Function?
    By MsChessie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-12-2014, 01:44 AM
  2. Explain Countif function
    By consultant_ in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-21-2012, 04:46 PM
  3. explain the FuzzyLookup function
    By cjGod in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-24-2008, 09:52 PM
  4. [SOLVED] Please explain function/formula
    By Tara H in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-24-2006, 02:20 PM
  5. [SOLVED] can someone explain function 'ara'?
    By feachmarsin in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2006, 08:30 PM
  6. Explain Function problem
    By martin23 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-20-2005, 07:17 AM
  7. Function behaviour, can someone explain please?
    By Ron in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-08-2005, 12:06 PM

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