Alphabetical - A

ABSThe absolute value or a number without its sign.
ACCRINTThe accrued interest for a security that pays interest periodically.
ACCRINTMThe accrued interest for a security that pays interest at maturity.
ACOSThe arc-cosine of a number.
ACOSHThe hyperbolic arc-cosine of a number.
ACOTThe arc-cotangent of a number.
ACOTHThe hyperbolic arc-cotangent of a number.
ADDRESSThe cell reference given a row and column number.
AGGREGATEThe choice of 19 different operations for numerical values which can ignore hidden rows and errors.
AMORDEGRCThe depreciation of an asset in a single period (straight-line, implicit coefficient).
AMORLINCThe depreciation of an asset in a single period (straight-line).
ANDThe boolean True or False depending on multiple conditions.
ARABICThe number converted from roman to arabic.
AREASThe number of areas in a cell range or reference.
ARRAYTOTEXT(2021) New. The contents of an array or cell range converted to text.
ASC(Japanese) The text string converted from double byte to single byte characters.
ASINThe arc-sine of a number.
ASINHThe hyperbolic arc-sine of a number.
ATANThe arc-tangent of a number.
ATAN2The arc-tangent of the given x and y co-ordinates.
ATANHThe hyperbolic arc-tangent of a number.
AVEDEVThe average deviation of the numerical values.
AVERAGEThe arithmetic mean of the numerical values.
AVERAGEAThe arithmetic mean of the numerical values (including logical values and text).
AVERAGEIF(AVERAGEIFS) The arithmetic mean of the numerical values that satisfies one condition.
AVERAGEIFSThe arithmetic mean of the numerical values that satisfies multiple conditions.
ABS
The absolute value or a number without its sign.
ACCRINT
The accrued interest for a security that pays interest periodically.
ACCRINTM
The accrued interest for a security that pays interest at maturity.
ACOS
The arc-cosine of a number.
ACOSH
The hyperbolic arc-cosine of a number.
ACOT
The arc-cotangent of a number.
ACOTH
The hyperbolic arc-cotangent of a number.
ADDRESS
The cell reference given a row and column number.
AGGREGATE
The choice of 19 different operations for numerical values which can ignore hidden rows and errors.
AMORDEGRC
The depreciation of an asset in a single period (straight-line, implicit coefficient).
AMORLINC
The depreciation of an asset in a single period (straight-line).
AND
The boolean True or False depending on multiple conditions.
ARABIC
The number converted from roman to arabic.
AREAS
The number of areas in a cell range or reference.
ARRAYTOTEXT
(2021) New. The contents of an array or cell range converted to text.
ASC
(Japanese) The text string converted from double byte to single byte characters.
ASIN
The arc-sine of a number.
ASINH
The hyperbolic arc-sine of a number.
ATAN
The arc-tangent of a number.
ATAN2
The arc-tangent of the given x and y co-ordinates.
ATANH
The hyperbolic arc-tangent of a number.
AVEDEV
The average deviation of the numerical values.
AVERAGE
The arithmetic mean of the numerical values.
AVERAGEA
The arithmetic mean of the numerical values (including logical values and text).
AVERAGEIF
(AVERAGEIFS) The arithmetic mean of the numerical values that satisfies one condition.
AVERAGEIFS
The arithmetic mean of the numerical values that satisfies multiple conditions.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top