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

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