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.

ABS | Math and trigonometry | Returns the absolute value of a number | |

ACCRINT | Financial | Returns the accrued interest for a security that pays periodic interest | |

ACCRINTM | Financial | Returns the accrued interest for a security that pays interest at maturity | |

ACOS | Math and trigonometry | Returns the arccosine of a number | |

ACOSH | Math and trigonometry | Returns the inverse hyperbolic cosine of a number | |

ACOT | Math and trigonometry | Returns the arccotangent of a number | |

ACOTH | Math and trigonometry | Returns the hyperbolic arccotangent of a number | |

ADDRESS | Lookup and reference | Returns a reference as text to a single cell in a worksheet | |

AGGREGATE | Math and trigonometry | Returns an aggregate in a list or database | |

AMORDEGRC | Financial | Returns the depreciation for each accounting period by using a depreciation coefficient | |

AMORLINC | Financial | Returns the depreciation for each accounting period | |

AND | Logical | Returns TRUE if all of its arguments are TRUE | |

ARABIC | Math and trigonometry | Converts a Roman number to Arabic, as a number | |

AREAS | Lookup and reference | Returns the number of areas in a reference | |

ASC | Text | Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters | |

ASIN | Math and trigonometry | Returns the arcsine of a number | |

ASINH | Math and trigonometry | Returns the inverse hyperbolic sine of a number | |

ATAN | Math and trigonometry | Returns the arctangent of a number | |

ATAN2 | Math and trigonometry | Returns the arctangent from x- and y-coordinates | |

ATANH | Math and trigonometry | Returns the inverse hyperbolic tangent of a number |