### Alphabetical A - M

List of user defined functions

ACRONYM | Returns the first letter of each word. |

AGE | Returns the age of a person given a birthday. |

AVERAGEIF | Returns the average value of cells that satisfies one condition. |

AVERAGEIFSVISIBLE | Returns the average of the visible non blank cells that satisfies multiple condition. |

AVERAGEIFVISIBLE | Returns the average of the visible non blank cells that satisfies one condition. |

AVERAGETOP | Returns the average from a range of values only considering the top "x" values. |

AVERAGEVISIBLE | |

BETWEEN | Returns whether a particular cell value is between a range of values. |

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

COLUMNWIDTH | Returns the column width of the active cell. |

COMMENTGET | Returns the comment associated with a particular cell. |

COMPUTERNAME | Returns the full computer name of where the code is running. |

CONTAINS | Returns whether a string is contained inside another string. |

COUNTFORMAT | Returns the number of cells that have been formatted with a particular colour. |

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

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

COUNTNUMBEROFDAYS | Returns the number of days in a month and/or year. |

COUNTNUMBEROFDAYS | Returns the number of days in a week, month, year |

COUNTSUBSTRING | Returns the number of times a substring occurs in a longer string. |

COUNTTEXTCELLS | Returns the number of cells that contain text. |

COUNTVISIBLE | Returns the number of visible non blank cells. |

DATEUNITS | Returns the number of units between two dates. |

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

EXTRACTFILENAME | Returns just the file name from a full file path. |

EXTRACTFILEPATH | Returns just the file path from a full file path. |

EXTRACTNUMBERS | Returns only the numbers from a text string. |

EXTRACTTEXT | Returns only the text from a text string. |

FILEEXISTS | Returns whether a particular file exists. |

FINDMATCH | Returns the position of an item in a list. |

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

FOLDEREXISTS | Returns whether a particular folder exists. |

FORMATGET | Returns the font colour index used to format a particular cell. |

FORMATGET_FONTNAME | Returns the font name used to format a particular cell. |

FORMATGET_FONTSIZE | Returns the font size used to format a particular cell. |

FORMULAGET | Returns the formula from a particular cell. |

HYPERLINKGET | Returns the hyperlink associated with a particular cell. |

IFERROR | Returns a value or something else when it returns an error. |

INVERSE | Returns the number divided into 1. |

ISBOLD | Returns whether a particular cell has bold formatting applied. |

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 number is an integer number. |

ISITALIC | Returns whether a particular cell has italic formatting applied. |

ISLIKE | Returns whether a particular string matches a certain pattern. |

ISLOCKED | Returns whether a particular cell is locked or not. |

ISLOWER | Returns whether a particular string is in lower case. |

ISMERGED | Returns whether a particular cell is merged or not. |

ISPRIME | Returns whether a particular number is a prime number. |

ISPROPER | Returns whether a particular string is in proper case. |

ISUNDERLINE | Returns whether a particular cell has underline formatting applied to it. |

ISUPPER | Returns whether a particular string is in upper case. |

ISWRAPPED | Returns whether a particular cell has text wrap formatting applied. |

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

LASTWORD | Returns the last word from a text string. |

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

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

MAXIF | Returns the largest value in a range of values that match a certain condition. |

MAXIFSVISIBLE | Returns the largest of the visible non blank cells that satisfies multiple condition. |

MAXIFVISIBLE | Returns the largest of the visible non blank cells that satisfies one condition. |

MEDIANIF | Returns the middle value in a range of values that satisfies one condition. |

MEDIANIFS | Returns the middle value in a range of values that satisfies multiple conditions. |

MEDIANIFSVISIBLE | Returns the middle value from visible non blank cells that satisfies multiple conditions. |

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

MINIF | Returns the smallest value in a range of values that satisfies one condition. |

MINIFSVISIBLE | Returns the smallest of the visible non blank cells that satisfies multiple condition. |

MINIFVISIBLE | Returns the smallest of the visible non blank cells that satisfies one condition. |

ACRONYMReturns the first letter of each word. |

AGEReturns the age of a person given a birthday. |

AVERAGEIFReturns the average value of cells that satisfies one condition. |

AVERAGEIFSVISIBLEReturns the average of the visible non blank cells that satisfies multiple condition. |

AVERAGEIFVISIBLEReturns the average of the visible non blank cells that satisfies one condition. |

AVERAGETOPReturns the average from a range of values only considering the top "x" values. |

AVERAGEVISIBLE |

BETWEENReturns whether a particular cell value is between a range of values. |

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

COLUMNWIDTHReturns the column width of the active cell. |

COMMENTGETReturns the comment associated with a particular cell. |

COMPUTERNAMEReturns the full computer name of where the code is running. |

CONTAINSReturns whether a string is contained inside another string. |

COUNTFORMATReturns the number of cells that have been formatted with a particular colour. |

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

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

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

COUNTNUMBEROFDAYSReturns the number of days in a week, month, year |

COUNTSUBSTRINGReturns the number of times a substring occurs in a longer string. |

COUNTTEXTCELLSReturns the number of cells that contain text. |

COUNTVISIBLEReturns the number of visible non blank cells. |

DATEUNITSReturns the number of units between two dates. |

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

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

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

EXTRACTNUMBERSReturns only the numbers from a text string. |

EXTRACTTEXTReturns only the text from a text string. |

FILEEXISTSReturns whether a particular file exists. |

FINDMATCHReturns the position of an item in a list. |

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

FOLDEREXISTSReturns whether a particular folder exists. |

FORMATGETReturns the font colour index used to format a particular cell. |

FORMATGET_FONTNAMEReturns the font name used to format a particular cell. |

FORMATGET_FONTSIZEReturns the font size used to format a particular cell. |

FORMULAGETReturns the formula from a particular cell. |

HYPERLINKGETReturns the hyperlink associated with a particular cell. |

IFERRORReturns a value or something else when it returns an error. |

INVERSEReturns the number divided into 1. |

ISBOLDReturns whether a particular cell has bold formatting applied. |

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 number is an integer number. |

ISITALICReturns whether a particular cell has italic formatting applied. |

ISLIKEReturns whether a particular string matches a certain pattern. |

ISLOCKEDReturns whether a particular cell is locked or not. |

ISLOWERReturns whether a particular string is in lower case. |

ISMERGEDReturns whether a particular cell is merged or not. |

ISPRIMEReturns whether a particular number is a prime number. |

ISPROPERReturns whether a particular string is in proper case. |

ISUNDERLINEReturns whether a particular cell has underline formatting applied to it. |

ISUPPERReturns whether a particular string is in upper case. |

ISWRAPPEDReturns whether a particular cell has text wrap formatting applied. |

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

LASTWORDReturns the last word from a text string. |

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

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

MAXIFReturns the largest value in a range of values that match a certain condition. |

MAXIFSVISIBLEReturns the largest of the visible non blank cells that satisfies multiple condition. |

MAXIFVISIBLEReturns the largest of the visible non blank cells that satisfies one condition. |

MEDIANIFReturns the middle value in a range of values that satisfies one condition. |

MEDIANIFSReturns the middle value in a range of values that satisfies multiple conditions. |

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

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

MINIFReturns the smallest value in a range of values that satisfies one condition. |

MINIFSVISIBLEReturns the smallest of the visible non blank cells that satisfies multiple condition. |

MINIFVISIBLEReturns the smallest of the visible non blank cells that satisfies one condition. |

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