Excel Functions Complete List

User Defined Functions Complete List

ACRONYM	Returns the first letter of each word.
AGE	Returns the age of a person given a birthday.
ALLSHEETS	Returns the min, max or sum of the identical cells across all worksheets.
AVERAGEAVISIBLE	Returns the average value from the visible, non blank cells in a range (including logical values and text).
AVERAGEIFSVISIBLE	Returns the average value from the visible, non blank cells that satisfy multiple conditions.
AVERAGETOP	Returns the average value from the cells with the top "x" values or percentage.
AVERAGEVISIBLE	Returns the average value from the visible, non blank cells.
CELLTYPE	Returns the type of value that is contained in a particular cell.
COLUMNWIDTH	Returns the column width of a particular cell.
COMMENTGET	Returns the comment associated with a particular cell.
COMPUTERNAME	Returns the full computer name.
CONTAINS	Returns whether a string is contained inside another string.
COUNTAVISIBLE	Returns the number of visible, non blank cells in a range (including logical values and text).
COUNTBETWEEN	Returns the number of cells that have a value that is between a range.
COUNTFORMAT	Returns the number of cells that have a particular cell color or font color.
COUNTIFSVISIBLE	Returns the number of visible, non blank cells that satisfy multiple conditions.
COUNTNUMBEROFDAYS	Returns the number of days in a particular month or year.
COUNTSUBSTRING	Returns the number of occurrences of a substring in a particular cell.
COUNTTEXTCELLS	Returns the number of cells that contain text.
COUNTVISIBLE	Returns the number of visible, non blank cells in a range.
DATEUNITS	Returns the number of units between two dates.
DATESBEFORE1900	Returns the results of adding and subtracting dates before 1900 which are represented as text.
DATEWHICHDAY	Returns the date given a month, a week number and a day of the week.
DAYSTOCHRISTMAS	Returns the number of days to Christmas.
EXCELDIR	Returns the various folder locations that Excel uses including installation and startup.
EXTRACTFILENAME	Returns only the file name from a full file path.
EXTRACTFILEPATH	Returns only the file path from a full file path.
EXTRACTFOLDERPATH	Returns only the folder path from a full file path.
EXTRACTNUMBERS	Returns only the numbers from a text string.
EXTRACTTEXT	Returns only the text from a text string that contains other characters as well.
FILEEXISTS	Returns whether a particular file exists.
FILEPROPERTIES	Returns built-in or custom document properties from the active workbook.
FINDMATCH	Returns the position of an item in a list.
FIRSTDATE	Returns the date of the first day of a week, month or year.
FIRSTWORD	Returns the first word from a text string.
FOLDEREXISTS	Returns whether a particular folder exists.
FORMATGET	Returns a specific formatting attribute from a particular cell.
HLOOKUPINTERPOLATE	Returns an interpolated value if an exact match is not found.
HYPERLINKGET	Returns the hyperlink associated with a particular cell.
IMAGEDISPLAY	Returns an image in the top left corner of the active cell.
INSERTSTRING	Returns the text string with a substring inserted in the middle.
INVERSE	Returns the number divided into 1.
ISBETWEEN	Returns whether a particular cell value is between a range.
ISBOLD	Returns whether a particular cell has been formatted in bold.
ISDATE	Returns whether a date is the first (or last) of a week, month or year.
ISFORMULA	Returns whether a particular cell contains a formula.
ISINTEGER	Returns whether a particular cell contains an integer number.
ISITALIC	Returns whether a particular cell has been formatted in italic.
ISLIKE	Returns whether a particular cell contains a string that matches a certain pattern.
ISLOCKED	Returns whether a particular cell has been locked.
ISLOWER	Returns whether a particular cell has been formatted in lower case.
ISMERGED	Returns whether a particular cell has been merged.
ISPRIME	Returns whether a particular cell contains a prime number.
ISPROPER	Returns whether a particular cell has been formatted in proper case.
ISUNDERLINE	Returns whether a particular cell has been formatted in underline.
ISUPPER	Returns whether a particular cell has been formatted in upper case.
ISWRAPPED	Returns whether a particular cell has been formatted with text wrap.
LASTDATE	Returns the date of the last day of a week, month or year.
LASTINCOLUMN	Returns the last cell that contains data in a particular column.
LASTINROW	Returns the last cell that contains data in a particular row.
LASTWORD	Returns the last word from a text string.
MAXAVISIBLE	Returns the largest value from the visible, non blank cells (including logical values and text).
MAXBETWEEN	Returns the largest value that is between a range.
MAXIFSVISIBLE	Returns the largest value from the visible, non blank cells that satisfy multiple conditions.
MAXVISIBLE	Returns the largest value from the visible, non blank cells.
MEDIANIFS	Returns the middle value from the cells that satisfy multiple conditions.
MEDIANIFSVISIBLE	Returns the middle value from the visible, non blank cells that satisfy multiple conditions.
MEDIANVISIBLE	Returns the middle value from the visible cells.
MERGECELLS	Returns the text string that is a concatenation of several strings or values.
MINAVISIBLE	Returns the smallest value from the visible, non blank cells (including logical values and text).
MINBETWEEN	Returns the smallest value that is between a range.
MINIFSVISIBLE	Returns the smallest value from the visible, non blank cells that satisfy multiple conditions.
MINVISIBLE	Returns the smallest value from the visible, non blank cells.
NETWORKDAYSMISC	Returns the number of days between two dates using a defined list of workdays.
NEXTWEEKDAY	Returns the date of the next weekday.
NONBLANKVALUES	Returns an array of all the non blank items in a range.
NUMBERFORMATGET	Returns the number format that has been applied to a particular cell.
NUMBERTOROMAN	Returns the text string converting a binary number to a roman numeral.
ORDINAL	Returns a number with its corresponding ordinal abbreviation.
PERCENTAGEIFS	Returns the percentage of values that satisfy multiple conditions.
PREVIOUSWEEKDAY	Returns the date of the previous weekday.
RANDOMNUMBER	Returns a random number between two intervals.
RANDOMPASSWORD	Returns a specific number of random ASCII characters.
REMOVEDUPLICATES	Returns the contents of a cell range ignoring all the duplicate values.
REMOVENUMBERS	Returns any numbers from a text string.
REMOVESPACES	Returns a text string with any spaces removed.
REMOVETEXT	Returns a text string with a substring removed.
REVERSE	Returns the contents of a particular cell with all the characters reversed.
ROWHEIGHT	Returns the row height of a particular cell.
SCRAMBLE	Returns the contents of a particular cell with all the characters in a random order.
SELECTONE	Returns a value at random from a range of cells.
SHEETOFFSET	Returns the contents of a cell on a different worksheet.
SPELLNUMBER	Returns the word equivalent for a numerical number.
SPELLNUMBERREVERSE	Returns the number equivalent for a number written as text.
SUMBETWEEN	Returns the sum of values that are between a range.
SUMDIGITS	Returns the sum of the digits in a particular cell.
SUMFORMAT	Returns the sum of values that have a particular cell color or font color.
SUMIFSVISIBLE	Returns the sum of values from the visible, non blank cells that satisfy multiple conditions.
SUMVISIBLE	Returns the sum of values from the visible, non blank cells.
UNIQUEITEMS	Returns an array of all the unique items in a range.
USERNAME	Returns the application's user name or the domain username.
VLOOKUPINTERPOLATE	Returns an interpolated value if an exact match is not found.
WEEKNUMBER	Returns the week number of a particular date.
WORDCOUNT	Returns the number of words in a particular cell.
WORDGET	Returns the nth element of a string that uses a separator character.
WORKBOOKFILEEXTENSION	Returns the file extension of the active workbook.
WORKBOOKFILENAME	Returns the file name of the active workbook.
WORKBOOKPATH	Returns the folder path of the active workbook.
WORKBOOKPATHFILENAME	Returns the folder path and file name of the active workbook.
WORKDAY6	Returns the serial number before or after a given number of days from a start date assuming a 6-day working week.
WORKDAYSMISC	Returns the serial number before or after a given number of days from a start date using a defined list of workdays.
WORKSHEETNAME	Returns the name of a worksheet in the active workbook given an index position.
WORKSHEETSCOUNT	Returns the total number of sheets in the active workbook.

ACRONYM Returns the first letter of each word.
AGE Returns the age of a person given a birthday.
ALLSHEETS Returns the min, max or sum of the identical cells across all worksheets.
AVERAGEAVISIBLE Returns the average value from the visible, non blank cells in a range (including logical values and text).
AVERAGEIFSVISIBLE Returns the average value from the visible, non blank cells that satisfy multiple conditions.
AVERAGETOP Returns the average value from the cells with the top "x" values or percentage.
AVERAGEVISIBLE Returns the average value from the visible, non blank cells.
CELLTYPE Returns the type of value that is contained in a particular cell.
COLUMNWIDTH Returns the column width of a particular cell.
COMMENTGET Returns the comment associated with a particular cell.
COMPUTERNAME Returns the full computer name.
CONTAINS Returns whether a string is contained inside another string.
COUNTAVISIBLE Returns the number of visible, non blank cells in a range (including logical values and text).
COUNTBETWEEN Returns the number of cells that have a value that is between a range.
COUNTFORMAT Returns the number of cells that have a particular cell color or font color.
COUNTIFSVISIBLE Returns the number of visible, non blank cells that satisfy multiple conditions.
COUNTNUMBEROFDAYS Returns the number of days in a particular month or year.
COUNTSUBSTRING Returns the number of occurrences of a substring in a particular cell.
COUNTTEXTCELLS Returns the number of cells that contain text.
COUNTVISIBLE Returns the number of visible, non blank cells in a range.
DATEUNITS Returns the number of units between two dates.
DATESBEFORE1900 Returns the results of adding and subtracting dates before 1900 which are represented as text.
DATEWHICHDAY Returns the date given a month, a week number and a day of the week.
DAYSTOCHRISTMAS Returns the number of days to Christmas.
EXCELDIR Returns the various folder locations that Excel uses including installation and startup.
EXTRACTFILENAME Returns only the file name from a full file path.
EXTRACTFILEPATH Returns only the file path from a full file path.
EXTRACTFOLDERPATH Returns only the folder path from a full file path.
EXTRACTNUMBERS Returns only the numbers from a text string.
EXTRACTTEXT Returns only the text from a text string that contains other characters as well.
FILEEXISTS Returns whether a particular file exists.
FILEPROPERTIES Returns built-in or custom document properties from the active workbook.
FINDMATCH Returns the position of an item in a list.
FIRSTDATE Returns the date of the first day of a week, month or year.
FIRSTWORD Returns the first word from a text string.
FOLDEREXISTS Returns whether a particular folder exists.
FORMATGET Returns a specific formatting attribute from a particular cell.
HLOOKUPINTERPOLATE Returns an interpolated value if an exact match is not found.
HYPERLINKGET Returns the hyperlink associated with a particular cell.
IMAGEDISPLAY Returns an image in the top left corner of the active cell.
INSERTSTRING Returns the text string with a substring inserted in the middle.
INVERSE Returns the number divided into 1.
ISBETWEEN Returns whether a particular cell value is between a range.
ISBOLD Returns whether a particular cell has been formatted in bold.
ISDATE Returns whether a date is the first (or last) of a week, month or year.
ISFORMULA Returns whether a particular cell contains a formula.
ISINTEGER Returns whether a particular cell contains an integer number.
ISITALIC Returns whether a particular cell has been formatted in italic.
ISLIKE Returns whether a particular cell contains a string that matches a certain pattern.
ISLOCKED Returns whether a particular cell has been locked.
ISLOWER Returns whether a particular cell has been formatted in lower case.
ISMERGED Returns whether a particular cell has been merged.
ISPRIME Returns whether a particular cell contains a prime number.
ISPROPER Returns whether a particular cell has been formatted in proper case.
ISUNDERLINE Returns whether a particular cell has been formatted in underline.
ISUPPER Returns whether a particular cell has been formatted in upper case.
ISWRAPPED Returns whether a particular cell has been formatted with text wrap.
LASTDATE Returns the date of the last day of a week, month or year.
LASTINCOLUMN Returns the last cell that contains data in a particular column.
LASTINROW Returns the last cell that contains data in a particular row.
LASTWORD Returns the last word from a text string.
MAXAVISIBLE Returns the largest value from the visible, non blank cells (including logical values and text).
MAXBETWEEN Returns the largest value that is between a range.
MAXIFSVISIBLE Returns the largest value from the visible, non blank cells that satisfy multiple conditions.
MAXVISIBLE Returns the largest value from the visible, non blank cells.
MEDIANIFS Returns the middle value from the cells that satisfy multiple conditions.
MEDIANIFSVISIBLE Returns the middle value from the visible, non blank cells that satisfy multiple conditions.
MEDIANVISIBLE Returns the middle value from the visible cells.
MERGECELLS Returns the text string that is a concatenation of several strings or values.
MINAVISIBLE Returns the smallest value from the visible, non blank cells (including logical values and text).
MINBETWEEN Returns the smallest value that is between a range.
MINIFSVISIBLE Returns the smallest value from the visible, non blank cells that satisfy multiple conditions.
MINVISIBLE Returns the smallest value from the visible, non blank cells.
NETWORKDAYSMISC Returns the number of days between two dates using a defined list of workdays.
NEXTWEEKDAY Returns the date of the next weekday.
NONBLANKVALUES Returns an array of all the non blank items in a range.
NUMBERFORMATGET Returns the number format that has been applied to a particular cell.
NUMBERTOROMAN Returns the text string converting a binary number to a roman numeral.
ORDINAL Returns a number with its corresponding ordinal abbreviation.
PERCENTAGEIFS Returns the percentage of values that satisfy multiple conditions.
PREVIOUSWEEKDAY Returns the date of the previous weekday.
RANDOMNUMBER Returns a random number between two intervals.
RANDOMPASSWORD Returns a specific number of random ASCII characters.
REMOVEDUPLICATES Returns the contents of a cell range ignoring all the duplicate values.
REMOVENUMBERS Returns any numbers from a text string.
REMOVESPACES Returns a text string with any spaces removed.
REMOVETEXT Returns a text string with a substring removed.
REVERSE Returns the contents of a particular cell with all the characters reversed.
ROWHEIGHT Returns the row height of a particular cell.
SCRAMBLE Returns the contents of a particular cell with all the characters in a random order.
SELECTONE Returns a value at random from a range of cells.
SHEETOFFSET Returns the contents of a cell on a different worksheet.
SPELLNUMBER Returns the word equivalent for a numerical number.
SPELLNUMBERREVERSE Returns the number equivalent for a number written as text.
SUMBETWEEN Returns the sum of values that are between a range.
SUMDIGITS Returns the sum of the digits in a particular cell.
SUMFORMAT Returns the sum of values that have a particular cell color or font color.
SUMIFSVISIBLE Returns the sum of values from the visible, non blank cells that satisfy multiple conditions.
SUMVISIBLE Returns the sum of values from the visible, non blank cells.
UNIQUEITEMS Returns an array of all the unique items in a range.
USERNAME Returns the application's user name or the domain username.
VLOOKUPINTERPOLATE Returns an interpolated value if an exact match is not found.
WEEKNUMBER Returns the week number of a particular date.
WORDCOUNT Returns the number of words in a particular cell.
WORDGET Returns the nth element of a string that uses a separator character.
WORKBOOKFILEEXTENSION Returns the file extension of the active workbook.
WORKBOOKFILENAME Returns the file name of the active workbook.
WORKBOOKPATH Returns the folder path of the active workbook.
WORKBOOKPATHFILENAME Returns the folder path and file name of the active workbook.
WORKDAY6 Returns the serial number before or after a given number of days from a start date assuming a 6-day working week.
WORKDAYSMISC Returns the serial number before or after a given number of days from a start date using a defined list of workdays.
WORKSHEETNAME Returns the name of a worksheet in the active workbook given an index position.
WORKSHEETSCOUNT Returns the total number of sheets in the active workbook.