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.
ACOT(2013) The arc-cotangent of a number.
ACOTH(2013) The hyperbolic arc-cotangent of a number.
ADDRESSThe cell reference given a row and column number.
AGGREGATE(2010) The aggregate of values in a list, table or cell range.
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 logical AND for any number of arguments.
ARABIC(2013) The number converted from roman to arabic.
AREASThe number of areas in a cell range or reference.
ASCThe 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 specified x and y co-ordinates.
ATANHThe hyperbolic arc-tangent of a number.
AVEDEVThe average deviation of the numbers in a list, table or cell range.
AVERAGEThe arithmetic mean of non blank cells in a list, table or cell range.
AVERAGEAThe arithmetic mean of non blank cells in a list, table or cell range (including logical values and text).
AVERAGEIFThe arithmetic mean of all the numbers in a range that satisfies one condition.
AVERAGEIFSThe arithmetic mean of all the numbers in a range 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
(2013) The arc-cotangent of a number.
ACOTH
(2013) The hyperbolic arc-cotangent of a number.
ADDRESS
The cell reference given a row and column number.
AGGREGATE
(2010) The aggregate of values in a list, table or cell range.
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 logical AND for any number of arguments.
ARABIC
(2013) The number converted from roman to arabic.
AREAS
The number of areas in a cell range or reference.
ASC
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 specified x and y co-ordinates.
ATANH
The hyperbolic arc-tangent of a number.
AVEDEV
The average deviation of the numbers in a list, table or cell range.
AVERAGE
The arithmetic mean of non blank cells in a list, table or cell range.
AVERAGEA
The arithmetic mean of non blank cells in a list, table or cell range (including logical values and text).
AVERAGEIF
The arithmetic mean of all the numbers in a range that satisfies one condition.
AVERAGEIFS
The arithmetic mean of all the numbers in a range that satisfies multiple conditions.

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