In Excel 2007, this is a Statistical function. Math and trigonometry: Converts a number into a text representation with the given radix (base)Įngineering: Returns the modified Bessel function In(x)Įngineering: Returns the Bessel function Jn(x)Įngineering: Returns the modified Bessel function Kn(x)Įngineering: Returns the Bessel function Yn(x)Ĭompatibility: Returns the beta cumulative distribution function Text: Converts a number to text, using the ß (baht) currency format 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
DOES EXCEL FOR MAC HAVE IFS PC
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.
0 kommentar(er)
