Complete List

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

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

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

Complete List

OUR SERVICES

THE COMMUNITY

THE BUSINESS

OUR PARTNERS