Advanced Functions

AGGREGATE(2010) The aggregate of values in a list, table or cell range.
CONVERTThe number in one measurement system converted to another.
COUNTThe number of non blank cells in a list, table or cell range.
COUNTIFSThe number of non blank cells in a list, table or cell range that satisfies multiple conditions.
DATEThe date as a date serial number given a year, month, day.
DATEDIFThe number of units between two dates.
EMBEDDisplayed in the formula bar when an embedded object is selected.
HLOOKUPThe value in a row that matches a value in the top row of a table.
INDEXThe value from a table based on an index number.
INDIRECTThe text string of the contents of a given cell reference.
LINESTThe array of values for a straight line that best fits your data.
LOOKUPThe value in a row (or column) that matches a value in a column (or row).
MATCHThe position of a value in a list, table or cell range.
OFFSETThe value in a cell which is an offset from another cell.
PERCENTILE.INC(2010) The number corresponding to a particular percentage from an array of numbers (inclusive).
RANK.EQ(2010) The rank of a value in a list, table or cell range (in descending order).
REGISTER.IDThe registered id for a specified dynamic link library (DLL).
SUBTOTALThe subtotal of values in a list, table or cell range.
SUMIFSThe total value of the numbers that satisfies multiple conditions.
SUMPRODUCTThe sum of the product of one or more arrays of values.
VLOOKUPThe value in a column that matches a value in the first column of a table.
AGGREGATE
(2010) The aggregate of values in a list, table or cell range.
CONVERT
The number in one measurement system converted to another.
COUNT
The number of non blank cells in a list, table or cell range.
COUNTIFS
The number of non blank cells in a list, table or cell range that satisfies multiple conditions.
DATE
The date as a date serial number given a year, month, day.
DATEDIF
The number of units between two dates.
EMBED
Displayed in the formula bar when an embedded object is selected.
HLOOKUP
The value in a row that matches a value in the top row of a table.
INDEX
The value from a table based on an index number.
INDIRECT
The text string of the contents of a given cell reference.
LINEST
The array of values for a straight line that best fits your data.
LOOKUP
The value in a row (or column) that matches a value in a column (or row).
MATCH
The position of a value in a list, table or cell range.
OFFSET
The value in a cell which is an offset from another cell.
PERCENTILE.INC
(2010) The number corresponding to a particular percentage from an array of numbers (inclusive).
RANK.EQ
(2010) The rank of a value in a list, table or cell range (in descending order).
REGISTER.ID
The registered id for a specified dynamic link library (DLL).
SUBTOTAL
The subtotal of values in a list, table or cell range.
SUMIFS
The total value of the numbers that satisfies multiple conditions.
SUMPRODUCT
The sum of the product of one or more arrays of values.
VLOOKUP
The value in a column that matches a value in the first column of a table.

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