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.
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.

© 2018 Better Solutions Limited. All Rights Reserved. © 2018 Better Solutions Limited

Top

PrevNext