Advanced Functions

AVERAGEIFS	The arithmetic mean of all the numbers in a range that satisfies multiple conditions.
CONVERT	The number in one measurement system converted to another.
DATE	The date as a date serial number given a year, month, day.
DATEDIF	(Compatibility) The number of days, months or years between two dates.
EMBED	Displayed in the formula bar when an embedded object is selected.
IFS	The value based on multiple True or False conditions.
LET	The result of a formula that can use variables.
LINEST	The array of values for a straight line that best fits your data.
PERCENTILE.INC	The number corresponding to a particular percentage from an array of numbers (inclusive).
RANK.EQ	The rank of a value in a list, table or cell range (in descending order).
REGEXTEST	The boolean True or False depending if the regular expression matches any part of a text string.

AVERAGEIFS The arithmetic mean of all the numbers in a range that satisfies multiple conditions.
CONVERT The number in one measurement system converted to another.
DATE The date as a date serial number given a year, month, day.
DATEDIF (Compatibility) The number of days, months or years between two dates.
EMBED Displayed in the formula bar when an embedded object is selected.
IFS The value based on multiple True or False conditions.
LET The result of a formula that can use variables.
LINEST The array of values for a straight line that best fits your data.
PERCENTILE.INC The number corresponding to a particular percentage from an array of numbers (inclusive).
RANK.EQ The rank of a value in a list, table or cell range (in descending order).
REGEXTEST The boolean True or False depending if the regular expression matches any part of a text string.