### User Defined Functions

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. |

AVERAGEIF | Returns the average value from the cells that satisfy one condition. |

AVERAGEIFSVISIBLE | Returns the average value from the visible, non blank cells that satisfy multiple conditions. |

AVERAGEIFVISIBLE | Returns the average value from the visible, non blank cells that satisfy one condition. |

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. |

COUNTFORMAT_CELLCOLOR | |

COUNTFORMAT_FONTBOLD | |

COUNTFORMAT_FONTCOLOR | |

COUNTIFSVISIBLE | Returns the number of visible, non blank cells that satisfy multiple conditions. |

COUNTIFVISIBLE | Returns the number of visible, non blank cells that satisfy one condition. |

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. |

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. |

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 | |

FOLDEREXISTS | Returns whether a particular folder exists. |

FORMATGET | Returns a specific formatting attribute from a particular cell. |

FORMULAGET | Returns the formula 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. |

IFERROR | (Added in 2017) Returns a value or something else when it returns an error. |

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 in a particular cell. |

MAXBETWEEN | Returns the largest value that is between a range. |

MAXIF | (MAXIFS added in 2016 January) Returns the largest value from the cells that satisfy one condition. |

MAXIFSVISIBLE | Returns the largest value from the visible, non blank cells that satisfy multiple conditions. |

MAXIFVISIBLE | Returns the largest value from the visible, non blank cells that satisfy one condition. |

MAXVISIBLE | Returns the largest value from the visible, non blank cells. |

MEDIANIF | Returns the middle value from the cells that satisfy one condition. |

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. |

MEDIANIFVISIBLE | Returns the middle value from the visible, non blank cells that satisfy one condition. |

MERGECELLS | Returns the text string that is a concatenation of several strings or values. |

MINBETWEEN | Returns the smallest value that is between a range. |

MINIF | (MINIFS added in 2016 January) Returns the smallest value from the cells that satisfy one condition. |

MINIFSVISIBLE | Returns the smallest value from the visible, non blank cells that satisfy multiple conditions. |

MINIFVISIBLE | Returns the smallest value from the visible, non blank cells that satisfy one condition. |

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. |

PERCENTAGEIF | Returns the percentage of values that satisfy one condition. |

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. |

REMOVENUMBERS | Returns any numbers from a text string. |

REMOVESPACES | Returns a text string with any spaces 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. |

SUMFORMAT_CELLCOLOR | |

SUMFORMAT_FONTCOLOR | |

SUMIFSVISIBLE | Returns the sum of values from the visible, non blank cells that satisfy multiple conditions. |

SUMIFVISIBLE | Returns the sum of values from the visible, non blank cells that satisfy one condition. |

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 | |

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. |

ACRONYMReturns the first letter of each word. |

AGEReturns the age of a person given a birthday. |

ALLSHEETSReturns the min, max or sum of the identical cells across all worksheets. |

AVERAGEIFReturns the average value from the cells that satisfy one condition. |

AVERAGEIFSVISIBLEReturns the average value from the visible, non blank cells that satisfy multiple conditions. |

AVERAGEIFVISIBLEReturns the average value from the visible, non blank cells that satisfy one condition. |

AVERAGETOPReturns the average value from the cells with the top "x" values or percentage. |

AVERAGEVISIBLEReturns the average value from the visible, non blank cells. |

CELLTYPEReturns the type of value that is contained in a particular cell. |

COLUMNWIDTHReturns the column width of a particular cell. |

COMMENTGETReturns the comment associated with a particular cell. |

COMPUTERNAMEReturns the full computer name. |

CONTAINSReturns whether a string is contained inside another string. |

COUNTAVISIBLEReturns the number of visible, non blank cells in a range (including logical values and text). |

COUNTBETWEENReturns the number of cells that have a value that is between a range. |

COUNTFORMATReturns the number of cells that have a particular cell color or font color. |

COUNTFORMAT_CELLCOLOR |

COUNTFORMAT_FONTBOLD |

COUNTFORMAT_FONTCOLOR |

COUNTIFSVISIBLEReturns the number of visible, non blank cells that satisfy multiple conditions. |

COUNTIFVISIBLEReturns the number of visible, non blank cells that satisfy one condition. |

COUNTNUMBEROFDAYSReturns the number of days in a particular month or year. |

COUNTSUBSTRINGReturns the number of occurrences of a substring in a particular cell. |

COUNTTEXTCELLSReturns the number of cells that contain text. |

COUNTVISIBLEReturns the number of visible, non blank cells in a range. |

DATESBEFORE1900Returns the results of adding and subtracting dates before 1900 which are represented as text. |

DATEWHICHDAYReturns the date given a month, a week number and a day of the week. |

EXCELDIRReturns the various folder locations that Excel uses including installation and startup. |

EXTRACTFILENAMEReturns only the file name from a full file path. |

EXTRACTFILEPATHReturns only the file path from a full file path. |

EXTRACTFOLDERPATHReturns only the folder path from a full file path. |

EXTRACTNUMBERSReturns only the numbers from a text string. |

EXTRACTTEXTReturns only the text from a text string that contains other characters as well. |

FILEEXISTSReturns whether a particular file exists. |

FILEPROPERTIESReturns built-in or custom document properties from the active workbook. |

FINDMATCHReturns the position of an item in a list. |

FIRSTDATEReturns the date of the first day of a week, month or year. |

FIRSTWORD |

FOLDEREXISTSReturns whether a particular folder exists. |

FORMATGETReturns a specific formatting attribute from a particular cell. |

FORMULAGETReturns the formula from a particular cell. |

HLOOKUPINTERPOLATEReturns an interpolated value if an exact match is not found. |

HYPERLINKGETReturns the hyperlink associated with a particular cell. |

IFERROR(Added in 2017) Returns a value or something else when it returns an error. |

IMAGEDISPLAYReturns an image in the top left corner of the active cell. |

INSERTSTRINGReturns the text string with a substring inserted in the middle. |

INVERSEReturns the number divided into 1. |

ISBETWEENReturns whether a particular cell value is between a range. |

ISBOLDReturns whether a particular cell has been formatted in bold. |

ISDATEReturns whether a date is the first (or last) of a week, month or year. |

ISFORMULAReturns whether a particular cell contains a formula. |

ISINTEGERReturns whether a particular cell contains an integer number. |

ISITALICReturns whether a particular cell has been formatted in italic. |

ISLIKEReturns whether a particular cell contains a string that matches a certain pattern. |

ISLOCKEDReturns whether a particular cell has been locked. |

ISLOWERReturns whether a particular cell has been formatted in lower case. |

ISMERGEDReturns whether a particular cell has been merged. |

ISPRIMEReturns whether a particular cell contains a prime number. |

ISPROPERReturns whether a particular cell has been formatted in proper case. |

ISUNDERLINEReturns whether a particular cell has been formatted in underline. |

ISUPPERReturns whether a particular cell has been formatted in upper case. |

ISWRAPPEDReturns whether a particular cell has been formatted with text wrap. |

LASTDATEReturns the date of the last day of a week, month or year. |

LASTINCOLUMNReturns the last cell that contains data in a particular column. |

LASTINROWReturns the last cell that contains data in a particular row. |

LASTWORDReturns the last word in a particular cell. |

MAXBETWEENReturns the largest value that is between a range. |

MAXIF(MAXIFS added in 2016 January) Returns the largest value from the cells that satisfy one condition. |

MAXIFSVISIBLEReturns the largest value from the visible, non blank cells that satisfy multiple conditions. |

MAXIFVISIBLEReturns the largest value from the visible, non blank cells that satisfy one condition. |

MAXVISIBLEReturns the largest value from the visible, non blank cells. |

MEDIANIFReturns the middle value from the cells that satisfy one condition. |

MEDIANIFSReturns the middle value from the cells that satisfy multiple conditions. |

MEDIANIFSVISIBLEReturns the middle value from the visible, non blank cells that satisfy multiple conditions. |

MEDIANIFVISIBLEReturns the middle value from the visible, non blank cells that satisfy one condition. |

MERGECELLSReturns the text string that is a concatenation of several strings or values. |

MINBETWEENReturns the smallest value that is between a range. |

MINIF(MINIFS added in 2016 January) Returns the smallest value from the cells that satisfy one condition. |

MINIFSVISIBLEReturns the smallest value from the visible, non blank cells that satisfy multiple conditions. |

MINIFVISIBLEReturns the smallest value from the visible, non blank cells that satisfy one condition. |

MINVISIBLEReturns the smallest value from the visible, non blank cells. |

NETWORKDAYSMISCReturns the number of days between two dates using a defined list of workdays. |

NEXTWEEKDAYReturns the date of the next weekday. |

NONBLANKVALUESReturns an array of all the non blank items in a range. |

NUMBERFORMATGETReturns the number format that has been applied to a particular cell. |

NUMBERTOROMANReturns the text string converting a binary number to a roman numeral. |

ORDINALReturns a number with its corresponding ordinal abbreviation. |

PERCENTAGEIFReturns the percentage of values that satisfy one condition. |

PERCENTAGEIFSReturns the percentage of values that satisfy multiple conditions. |

PREVIOUSWEEKDAYReturns the date of the previous weekday. |

RANDOMNUMBERReturns a random number between two intervals. |

RANDOMPASSWORDReturns a specific number of random ASCII characters. |

REMOVENUMBERSReturns any numbers from a text string. |

REMOVESPACESReturns a text string with any spaces removed. |

REVERSEReturns the contents of a particular cell with all the characters reversed. |

ROWHEIGHTReturns the row height of a particular cell. |

SCRAMBLEReturns the contents of a particular cell with all the characters in a random order. |

SELECTONEReturns a value at random from a range of cells. |

SHEETOFFSETReturns the contents of a cell on a different worksheet. |

SPELLNUMBERReturns the word equivalent for a numerical number. |

SPELLNUMBERREVERSEReturns the number equivalent for a number written as text. |

SUMBETWEENReturns the sum of values that are between a range. |

SUMDIGITSReturns the sum of the digits in a particular cell. |

SUMFORMATReturns the sum of values that have a particular cell color or font color. |

SUMFORMAT_CELLCOLOR |

SUMFORMAT_FONTCOLOR |

SUMIFSVISIBLEReturns the sum of values from the visible, non blank cells that satisfy multiple conditions. |

SUMIFVISIBLEReturns the sum of values from the visible, non blank cells that satisfy one condition. |

SUMVISIBLEReturns the sum of values from the visible, non blank cells. |

UNIQUEITEMSReturns an array of all the unique items in a range. |

USERNAMEReturns the application's user name or the domain username. |

VLOOKUPINTERPOLATEReturns an interpolated value if an exact match is not found. |

WEEKNUMBERReturns the week number of a particular date. |

WORDCOUNTReturns the number of words in a particular cell. |

WORDGET |

WORKBOOKFILEEXTENSIONReturns the file extension of the active workbook. |

WORKBOOKFILENAMEReturns the file name of the active workbook. |

WORKBOOKPATHReturns the folder path of the active workbook. |

WORKBOOKPATHFILENAMEReturns the folder path and file name of the active workbook. |

WORKDAY6Returns the serial number before or after a given number of days from a start date assuming a 6-day working week. |

WORKDAYSMISCReturns the serial number before or after a given number of days from a start date using a defined list of workdays. |

WORKSHEETNAMEReturns the name of a worksheet in the active workbook given an index position. |

WORKSHEETSCOUNTReturns the total number of sheets in the active workbook. |

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext