Functions By Category
Counting Functions
| 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 longer string. |
| COUNTVISIBLE | Returns the number of visible, non blank cells in a range. |
| COUNTVISIBLEIFS | Returns the number of non blank cells that satisfies multiple conditions. |
| 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 longer string. |
| COUNTVISIBLE Returns the number of visible, non blank cells in a range. |
| COUNTVISIBLEIFS Returns the number of non blank cells that satisfies multiple conditions. |
Summing Functions
| ADDNUMBERS | Returns the sum of a group of numbers. |
| 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. |
| ADDNUMBERS Returns the sum of a group of numbers. |
| 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. |
Text Functions
| ACRONYM | Returns the first letter of each word. |
| CONTAINS | Returns whether a string is contained inside another string. |
| EXTRACTNUMBERS | Returns only the numbers from a text string. |
| REMOVENUMBERS | Removes all numbers and spaces from a text string. |
| REVERSE | Returns the characters of a text string in reverse. |
| 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. |
| ACRONYM Returns the first letter of each word. |
| CONTAINS Returns whether a string is contained inside another string. |
| EXTRACTNUMBERS Returns only the numbers from a text string. |
| REMOVENUMBERS Removes all numbers and spaces from a text string. |
| REVERSE Returns the characters of a text string in reverse. |
| 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. |
Formatting Functions
| FORMATGET | Returns a specific formatting attribute from a particular cell. |
| NUMBERFORMATGET | Returns the number format that has been applied to a particular cell. |
| FORMATGET Returns a specific formatting attribute from a particular cell. |
| NUMBERFORMATGET Returns the number format that has been applied to a particular cell. |
Date & Time Functions
| AGE | Returns the age of a person given a birthday. |
| BUSDAYNEXT | Returns the date of the next business day. |
| BUSDAYPREVIOUS | Returns the date of the previous business day. |
| CONVERTTIME | Returns the time converted into decimal hours, minutes or seconds. |
| 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. |
| TIMENOW | Returns the current time as a string (in the format "hh:mm:ss"). |
| AGE Returns the age of a person given a birthday. |
| BUSDAYNEXT Returns the date of the next business day. |
| BUSDAYPREVIOUS Returns the date of the previous business day. |
| CONVERTTIME Returns the time converted into decimal hours, minutes or seconds. |
| 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. |
| TIMENOW Returns the current time as a string (in the format "hh:mm:ss"). |
Information Functions
| FILEEXISTS | Returns whether a particular file exists. |
| 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. |
| 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. |
| FILEEXISTS Returns whether a particular file exists. |
| 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. |
| 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. |
Maths Functions
| AVERAGEVISIBLEIFS | Returns the average value in a list or array of numbers that satisfies multiple conditions. |
| MAXVISIBLEIFS | Returns the largest value in a list or array of numbers that satisfies multiple conditions. |
| MINVISIBLEIFS | Returns the smallest value in a list or array of numbers that satisfies multiple conditions. |
| AVERAGEVISIBLEIFS Returns the average value in a list or array of numbers that satisfies multiple conditions. |
| MAXVISIBLEIFS Returns the largest value in a list or array of numbers that satisfies multiple conditions. |
| MINVISIBLEIFS Returns the smallest value in a list or array of numbers that satisfies multiple conditions. |
Other Functions
| COMMENTGET | Returns the comment associated with a particular cell. |
| COMPARECELLS | Returns a description of whether two ranges are identical or not. |
| 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. |
| HYPERLINKGET | Returns the hyperlink associated with a particular cell. |
| MERGECELLS | Returns the contents from all the cells and combines them to return a single string. |
| RANDOMPASSWORD | Returns a specific number of random ASCII characters. |
| SAMPLEDATA | Inserts sample data into the active worksheet. |
| COMMENTGET Returns the comment associated with a particular cell. |
| COMPARECELLS Returns a description of whether two ranges are identical or not. |
| 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. |
| HYPERLINKGET Returns the hyperlink associated with a particular cell. |
| MERGECELLS Returns the contents from all the cells and combines them to return a single string. |
| RANDOMPASSWORD Returns a specific number of random ASCII characters. |
| SAMPLEDATA Inserts sample data into the active worksheet. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext