Statistical: Returns the average (arithmetic mean) of all cells that meet multiple criteria. Statistical: Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria Statistical: Returns the average of its arguments, including numbers, text, and logical values Statistical: Returns the average of its arguments Statistical: Returns the average of the absolute deviations of data points from their mean Math and trigonometry: Returns the inverse hyperbolic tangent of a number Math and trigonometry: Returns the arctangent from x- and y-coordinates Math and trigonometry: Returns the arctangent of a number Math and trigonometry: Returns the inverse hyperbolic sine of a number Math and trigonometry: Returns the arcsine of a number

Text: Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters Text: Returns an array of text values from any specified range

Lookup and reference: Returns the number of areas in a reference Math and trigonometry: Converts a Roman number to Arabic, as a number Logical: Returns TRUE if all of its arguments are TRUE Lookup and reference: Returns a reference as text to a single cell in a worksheetįinancial: Returns the depreciation for each accounting period by using a depreciation coefficientįinancial: Returns the depreciation for each accounting period Math and trigonometry: Returns an aggregate in a list or database Math and trigonometry: Returns the hyperbolic arccotangent of a number Math and trigonometry: Returns the arccotangent of a number Math and trigonometry: Returns the inverse hyperbolic cosine of a number Math and trigonometry: Returns the arccosine of a number Math and trigonometry: Returns the absolute value of a numberįinancial: Returns the accrued interest for a security that pays periodic interestįinancial: Returns the accrued interest for a security that pays interest at maturity Important: The calculated results of formulas and some Excel worksheet functions may differ slightly between a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture.

Excel 2019 microsoft