### Alphabetical N - Z

List of user defined functions

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

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

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