Alphabetical N - Z

List of user defined functions

NETWORKDAYSMISCReturns the number of days between two dates using a defined list of workdays.
NEXTWEEKDAYReturns the date of the next weekday.
NUMBERFORMATGETReturns the number format used on 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 numbers in a range that meet a particular condition.
PERCENTAGEIFS 
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 cell contents with all the characters reversed.
ROWHEIGHTReturns the row height of the active cell.
SCRAMBLEReturns the contents of a cell with all the characters in a random order.
SELECTONEReturns a value at random from a range of cells.
SPELLNUMBERReturns the word equivalent for a numerical number.
SPELLNUMBERREVERSEReturns the number equivalent for a number written as text.
SUMFORMATReturns the sum of all the values that have been formatted with a particular colour.
SUMDIGITSReturns the sum of the digits in a cell.
SUMIFSVISIBLEReturns the sum of visible non blank cells that satisfies multiple conditions.
SUMIFVISIBLEReturns the sum of visible non blank cells that satisfies one condition.
SUMVISIBLEReturns the sum of 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.
WEEKNUMBERReturns the week number of a particular date.
WORKBOOKFILEEXTENSIONReturns the file extension
WORKBOOKFILENAMEReturns the name of the workbook (with or without file extension)
WORKBOOKPATHReturns the folder path of the active workbook.
WORKBOOKPATHFILENAMEReturns the folder path ad 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.
NETWORKDAYSMISC
Returns the number of days between two dates using a defined list of workdays.
NEXTWEEKDAY
Returns the date of the next weekday.
NUMBERFORMATGET
Returns the number format used on 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 numbers in a range that meet a particular condition.
PERCENTAGEIFS
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 cell contents with all the characters reversed.
ROWHEIGHT
Returns the row height of the active cell.
SCRAMBLE
Returns the contents of a cell with all the characters in a random order.
SELECTONE
Returns a value at random from a range of cells.
SPELLNUMBER
Returns the word equivalent for a numerical number.
SPELLNUMBERREVERSE
Returns the number equivalent for a number written as text.
SUMFORMAT
Returns the sum of all the values that have been formatted with a particular colour.
SUMDIGITS
Returns the sum of the digits in a cell.
SUMIFSVISIBLE
Returns the sum of visible non blank cells that satisfies multiple conditions.
SUMIFVISIBLE
Returns the sum of visible non blank cells that satisfies one condition.
SUMVISIBLE
Returns the sum of 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.
WEEKNUMBER
Returns the week number of a particular date.
WORKBOOKFILEEXTENSION
Returns the file extension
WORKBOOKFILENAME
Returns the name of the workbook (with or without file extension)
WORKBOOKPATH
Returns the folder path of the active workbook.
WORKBOOKPATHFILENAME
Returns the folder path ad 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