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 |