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 |