# Excel Functions

Syntax and Description with examples

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Filter by Categories

Excel functions are mathematical formulas that can be used to perform calculations or other actions on data in a worksheet.

Functions can be used to perform simple tasks, such as summing a column of numbers, or more complex tasks, such as calculating a mortgage payment.

Functions can be entered into a cell directly, or they can be used in conjunction with other formulas.

 TTEST Compatibility Returns the probability associated with a Student's t-test TYPE Information Returns a number indicating the data type of a value UNICHAR Text Returns the Unicode character that is references by the given numeric value UNICODE Text Returns the number (code point) that corresponds to the first character of the text UPPER Text Converts text to uppercase VALUE Text Converts a text argument to a number VAR Compatibility Estimates variance based on a sample VAR.P Statistical Calculates variance based on the entire population VAR.S Statistical Estimates variance based on a sample VARA Statistical Estimates variance based on a sample, including numbers, text, and logical values VARP Compatibility Calculates variance based on the entire population VARPA Statistical Calculates variance based on the entire population, including numbers, text, and logical values VDB Financial Returns the depreciation of an asset for a specified or partial period by using a declining balance method VLOOKUP Lookup and reference Looks in the first column of an array and moves across the row to return the value of a cell WEBSERVICE Web Returns data from a web service. WEEKDAY Date and time Converts a serial number to a day of the week WEEKNUM Date and time Converts a serial number to a number representing where the week falls numerically with a year WEIBULL Compatibility Calculates variance based on the entire population, including numbers, text, and logical values WEIBULL.DIST Statistical Returns the Weibull distribution WORKDAY Date and time Returns the serial number of the date before or after a specified number of workdays