Complete List

This is a complete list of all the additional functions organised by category.

ACRONYM	Returns the first letter of each word.
ADDNUMBERS	Returns the sum of a group of numbers.
AGE	Returns the age of a person given a birthday.
AVERAGEVISIBLE	Returns the average value in a list or array of numbers in only visible cells.
AVERAGEVISIBLEIFS	Returns the average value in a list or array of numbers that satisfies multiple conditions.
BUSDAYNEXT	Returns the date of the next business day.
BUSDAYPREVIOUS	Returns the date of the previous business day.
COMMENTGET	Returns the comment associated with a particular cell.
COMPARECELLS	Returns a description of whether two ranges are identical or not.
CONTAINS	Returns whether a string is contained inside another string.
CONVERTTIME	Returns the time converted to a decimal hours, minutes or seconds.
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.
COUNTHIDDENSHEETS	Returns the total number of hidden sheets in the active workbook.
COUNTSUBSTRING	Returns the number of times a substring occurs in a larger text string.
COUNTVISIBLE	Returns the number of non blank cells in only visible cells.
COUNTVISIBLEIFS	Returns the number of non blank cells that satisfies multiple conditions.
DATEDIFFERENCE	Returns the difference between two dates.
DATESERIAL	Returns the date serial number given a date in text format.
DAYSINAMONTH	Returns the number of days in a month and year.
DAYSINAYEAR	Returns the number of days in a year.
DAYSTO	Returns the number of days (or other units) to a specific event.
DAYSTOCHRISTMAS	Returns the number of days to Christmas.
DUPLICATECELLS	Returns the cell addresses of all the items that appear more than once.
DUPLICATEVALUES	Returns the list of items that appear more than once.
EMAILVALID	Returns whether a string is a valid email address.
EXTRACTFILENAME	Returns only the file name 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.
FILEEXISTS	Returns whether a particular file exists.
FORMATGET	Returns a specific formatting attribute from a particular cell.
HYPERLINKGET	Returns the hyperlink associated with a particular cell.
ISBOLD	Returns whether a particular cell has been formatted in bold.
LASTINCOLUMN	Returns the last cell that contains data in a particular column.
LASTINROW	Returns the last cell that contains data in a particular row.
MAXVISIBLE	Returns the largest value in only visible cells.
MAXVISIBLEIFS	Returns the largest value in a list or array of numbers that satisfies multiple conditions.
MERGECELLS	Returns the contents from all the cells and combines them to return a single string.
MINVISIBLE	Returns the smallest value in only visible cells.
MINVISIBLEIFS	Returns the smallest value in a list or array of numbers that satisfies multiple conditions.
NUMBERFORMATGET	Returns the number format that has been applied to a particular cell.
RANDOMPASSWORD	Returns a specific number of random ASCII characters.
REMOVENUMBERS	Removes all numbers and spaces from a text string.
REVERSE	Returns the characters of a text string in reverse.
SAMPLEDATA	Inserts sample data into the active worksheet.
SCRAMBLE	Returns the characters of a text string with all the characters in a random order.
SPELLNUMBER	Returns the text after converting a number into words.
SPELLNUMBERREVERSE	Returns the value after converting words into a number.
SUMFORMAT	Returns the sum of all the values that have been formatted with multiple attributes.
SUMVISIBLE	Returns the sum of values from the visible, non blank cells.
SUMVISIBLEIFS	Returns the total value of the numbers that satisfies multiple conditions.
TIMENOW	Returns the current time as a string (in the format "hh:mm:ss").
USERNAME	Returns the application's user name or the domain username.
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.
WORKBOOKPROPERTIES	Returns a particular workbook property of the active workbook.
WORKSHEETNAME	Returns the name of the worksheet in a given position.

ACRONYM Returns the first letter of each word.
ADDNUMBERS Returns the sum of a group of numbers.
AGE Returns the age of a person given a birthday.
AVERAGEVISIBLE Returns the average value in a list or array of numbers in only visible cells.
AVERAGEVISIBLEIFS Returns the average value in a list or array of numbers that satisfies multiple conditions.
BUSDAYNEXT Returns the date of the next business day.
BUSDAYPREVIOUS Returns the date of the previous business day.
COMMENTGET Returns the comment associated with a particular cell.
COMPARECELLS Returns a description of whether two ranges are identical or not.
CONTAINS Returns whether a string is contained inside another string.
CONVERTTIME Returns the time converted to a decimal hours, minutes or seconds.
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.
COUNTHIDDENSHEETS Returns the total number of hidden sheets in the active workbook.
COUNTSUBSTRING Returns the number of times a substring occurs in a larger text string.
COUNTVISIBLE Returns the number of non blank cells in only visible cells.
COUNTVISIBLEIFS Returns the number of non blank cells that satisfies multiple conditions.
DATEDIFFERENCE Returns the difference between two dates.
DATESERIAL Returns the date serial number given a date in text format.
DAYSINAMONTH Returns the number of days in a month and year.
DAYSINAYEAR Returns the number of days in a year.
DAYSTO Returns the number of days (or other units) to a specific event.
DAYSTOCHRISTMAS Returns the number of days to Christmas.
DUPLICATECELLS Returns the cell addresses of all the items that appear more than once.
DUPLICATEVALUES Returns the list of items that appear more than once.
EMAILVALID Returns whether a string is a valid email address.
EXTRACTFILENAME Returns only the file name 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.
FILEEXISTS Returns whether a particular file exists.
FORMATGET Returns a specific formatting attribute from a particular cell.
HYPERLINKGET Returns the hyperlink associated with a particular cell.
ISBOLD Returns whether a particular cell has been formatted in bold.
LASTINCOLUMN Returns the last cell that contains data in a particular column.
LASTINROW Returns the last cell that contains data in a particular row.
MAXVISIBLE Returns the largest value in only visible cells.
MAXVISIBLEIFS Returns the largest value in a list or array of numbers that satisfies multiple conditions.
MERGECELLS Returns the contents from all the cells and combines them to return a single string.
MINVISIBLE Returns the smallest value in only visible cells.
MINVISIBLEIFS Returns the smallest value in a list or array of numbers that satisfies multiple conditions.
NUMBERFORMATGET Returns the number format that has been applied to a particular cell.
RANDOMPASSWORD Returns a specific number of random ASCII characters.
REMOVENUMBERS Removes all numbers and spaces from a text string.
REVERSE Returns the characters of a text string in reverse.
SAMPLEDATA Inserts sample data into the active worksheet.
SCRAMBLE Returns the characters of a text string with all the characters in a random order.
SPELLNUMBER Returns the text after converting a number into words.
SPELLNUMBERREVERSE Returns the value after converting words into a number.
SUMFORMAT Returns the sum of all the values that have been formatted with multiple attributes.
SUMVISIBLE Returns the sum of values from the visible, non blank cells.
SUMVISIBLEIFS Returns the total value of the numbers that satisfies multiple conditions.
TIMENOW Returns the current time as a string (in the format "hh:mm:ss").
USERNAME Returns the application's user name or the domain username.
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.
WORKBOOKPROPERTIES Returns a particular workbook property of the active workbook.
WORKSHEETNAME Returns the name of the worksheet in a given position.

Complete List

OUR SERVICES

THE COMMUNITY

THE BUSINESS

OUR PARTNERS