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|