Excel Functions

Syntax and Description with examples

Search now!
Generic filters
Filter by Categories
Free Excel Macro
Premium Excel Macro
Add ins
Templates
VBA Codes

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