| GoTo | - | ACRONYM - Returns the first letter of each word. |
| GoTo | - | AGE - Returns the age of a person given a birthday. |
| GoTo | - | AVERAGEIF - Returns the average of a range of values that match a certain condition. |
| GoTo | - | AVERAGETOP - Returns the average from a range of values only considering the top "x" values. |
| GoTo | - | BETWEEN - Returns whether a particular cell value is between a range of values. |
| GoTo | - | CELLTYPE - Returns the type of value that is contained in a particular cell. |
| GoTo | - | COLOURCOUNT - Returns the number of cells that have been formatted with a particular colour. |
| GoTo | - | COLOURINDEX - Returns the colour index for a particular cell. |
| GoTo | - | COLOURSUM - Returns the sum of the all the values that have been formatted with a particular colour. |
| GoTo | - | COLUMNWIDTH - Returns the column width of the active cell. |
| GoTo | - | COMMENTGET - Returns the comment associated with a particular cell. |
| GoTo | - | CONTAINS - Returns whether a string is contained within another string. |
| GoTo | - | COUNTAVISIBLE - Returns the number of visible non blank cells. |
| GoTo | - | DATEFIRSTINMONTH - Returns ?? |
| GoTo | - | DATEPREVIOUSWEEKDAY - Returns the date of the previous weekday. |
| GoTo | - | DAYSINAMONTH - Returns the number of days in a particular month. |
| GoTo | - | DAYSINAYEAR - Returns the number of days in a particular year. |
| GoTo | - | EXTRACTFILENAME - Returns just the file name from a full file path. |
| GoTo | - | EXTRACTFILEPATH - Returns just the file path from a full file path. |
| GoTo | - | EXTRACTNUMBERS - Returns only the numbers from a text string. |
| GoTo | - | EXTRACTTEXT - Returns only the text from a text string. |
| GoTo | - | FILEEXISTS - Returns whether a particular file exists. |
| GoTo | - | FILENAME - Returns the name of the active workbook. |
| GoTo | - | FILEPATH - Returns the folder path of the active workbook. |
| GoTo | - | FINDINLIST - Returns the position of an item in a list. |
| GoTo | - | FOLDERPATH - Returns the folder path of the active workbook. |
| GoTo | - | FONTCOLORCOUNT - Returns the number of cells that have been formatted with a particular font. |
| GoTo | - | FONTCOLORINDEX - Returns the font colour index for a particular cell. |
| GoTo | - | FONTCOLORSUM - Returns the sum of the all the values that have been formatted with a particular font. |
| GoTo | - | FONTNAMEGET - Returns the font name used to format a particular cell. |
| GoTo | - | FONTSIZEGET - Returns the font size used to format a particular cell. |
| GoTo | - | FORMATCOUNT - Returns the number of cells that have a particular format. |
| GoTo | - | FORMULAGET - Returns the formula from a particular cell. |
| GoTo | - | FULLFILEPATH - Returns the folder path and file name of the active workbook. |
| GoTo | - | HYPERLINKGET - Returns the hyperlink associated with a particular cell. |
| GoTo | - | IFERROR - Returns ?? |
| GoTo | - | ISBOLD - Returns whether a particular cell has bold formatting applied to it. |
| GoTo | - | ISFORMULA - Returns whether a particular cell contains a formula. |
| GoTo | - | ISITALIC - Returns whether a particular cell has italic formatting applied to it. |
| GoTo | - | ISLIKE - Returns whether a particular string matches a certain pattern. |
| GoTo | - | ISUNDERLINE - Returns whether a particular cell has underline formatting applied to it. |
| GoTo | - | LASTINCOLUMN - Returns ?? |
| GoTo | - | LASTINROW - Returns ?? |
| GoTo | - | MAXIF - Returns the maximum value in a range of values that match a certain condition. |
| GoTo | - | MEDIANIF - Returns the median value in a range of values that match a certain condition. |
| GoTo | - | MINIF - Returns the minimum value in a range of values that match a certain condition. |
| GoTo | - | NETWORKDAYSMISC - Returns the number of days between two dates using a defined list of workdays. |
| GoTo | - | NUMBERFORMATGET - Returns the number format used on a particular cell. |
| GoTo | - | ORDINAL - Returns the ordinal ?? |
| GoTo | - | PERCENTARE - Returns the percentage of numbers in a range that meet a particular condition. |
| GoTo | - | RANDOMNUMBER - Returns a random number between 1 and 0. |
| GoTo | - | RANDOMPASSWORD - Returns ?? |
| GoTo | - | REMOVEBLANKS - Removes the blanks from a single column of data. |
| GoTo | - | REMOVENUMBERS - Removes any numbers from a text string. |
| GoTo | - | REMOVESPACES - Removes any spaces from a text string. |
| GoTo | - | REVERSE - Returns the cell contents with all the characters reversed. |
| GoTo | - | ROWHEIGHT - Returns the row height of the active cell. |
| GoTo | - | SCRAMBLE - Returns the cell contents with all the characters in a random order. |
| GoTo | - | SELECTONE - Returns a value at random from a range of cells. |
| GoTo | - | SHEETCOUNT - Returns the total number of sheets in the active workbook. |
| GoTo | - | SHEETNAME - Returns the name of a worksheet in the active workbook given an index position. |
| GoTo | - | SPELLNUMBER - Returns the word equivalent for a numerical number. |
| GoTo | - | SUBSTRINGCOUNT - Returns the number of times a substring occurs in a longer string. |
| GoTo | - | SUMVISIBLE - Returns the sum of the visible cells. |
| GoTo | - | UNIQUEITEMS - Returns an array of all the unique items in a range. |
| GoTo | - | USERNAME - Returns the user name from the (Tools > Options) dialog box. |
| GoTo | - | WEEKNUMBER - Returns the week number of a particular date. |
| GoTo | - | WORKBOOKNAME - Returns the file name of the active workbook. |
| GoTo | - | WORKBOOKPATH - Returns the folder path of the active workbook. |
| GoTo | - | WORKDAY6 - Returns the serial number before or after a given number of days from a start date assuming a 6-day working week. |
| GoTo | - | WORKDAYSMISC - Returns the serial number before or after a given number of days from a start date using a defined list of workdays. |