Excel formulas - English - XML
Excel formulas - English

IDFUNCTIONTYPEDESCRIPTIONNOTE
1ABSMath and trigonometryReturns the absolute value of a number
2ACCRINTFinancialReturns the accrued interest for a security that pays periodic interest
3ACCRINTMFinancialReturns the accrued interest for a security that pays interest at maturity
4ACOSMath and trigonometryReturns the arccosine of a number
5ACOSHMath and trigonometryReturns the inverse hyperbolic cosine of a number
6ACOTMath and trigonometryReturns the arccotangent of a number
7ACOTHMath and trigonometryReturns the hyperbolic arccotangent of a number
8AGGREGATEMath and trigonometryReturns an aggregate in a list or database
9ADDRESSLookup and referenceReturns a reference as text to a single cell in a worksheet
10AMORDEGRCFinancialReturns the depreciation for each accounting period by using a depreciation coefficient
11AMORLINCFinancialReturns the depreciation for each accounting period
12ANDLogicalReturns TRUE if all of its arguments are TRUE
13ARABICMath and trigonometryConverts a Roman number to Arabic, as a number
14AREASLookup and referenceReturns the number of areas in a reference
15ASCTextChanges full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
16ASINMath and trigonometryReturns the arcsine of a number
17ASINHMath and trigonometryReturns the inverse hyperbolic sine of a number
18ATANMath and trigonometryReturns the arctangent of a number
19ATAN2Math and trigonometryReturns the arctangent from x- and y-coordinates
20ATANHMath and trigonometryReturns the inverse hyperbolic tangent of a number
21AVEDEVStatisticalReturns the average of the absolute deviations of data points from their mean
22AVERAGEStatisticalReturns the average of its arguments
23AVERAGEAStatisticalReturns the average of its arguments, including numbers, text, and logical values
24AVERAGEIFStatisticalReturns the average (arithmetic mean) of all the cells in a range that meet a given criteria
25AVERAGEIFSStatisticalReturns the average (arithmetic mean) of all cells that meet multiple criteria.
26BAHTTEXTTextConverts a number to text, using the ß (baht) currency format
27BASEMath and trigonometryConverts a number into a text representation with the given radix (base)
28BESSELIEngineeringReturns the modified Bessel function In(x)
29BESSELJEngineeringReturns the Bessel function Jn(x)
30BESSELKEngineeringReturns the modified Bessel function Kn(x)
Tüm Sayfalarda Arama Yap

* Görseller ve İçerik tekif hakkına sahip olabilir