Excel Functions

Excel functions are mathematical formulas that can be used to perform calculations or other actions on data in a worksheet.

Functions can be used to perform simple tasks, such as summing a column of numbers, or more complex tasks, such as calculating a mortgage payment.

Functions can be entered into a cell directly, or they can be used in conjunction with other formulas.

Search

HLOOKUP	Lookup and reference		Looks in the top row of an array and returns the value of the indicated cell
HOUR	Date and time		Converts a serial number to an hour
HYPERLINK	Lookup and reference		Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
HYPGEOM.DIST	Statistical		Returns the hypergeometric distribution
HYPGEOMDIST	Compatibility		Returns the hypergeometric distribution
IF	Logical		Specifies a logical test to perform
IFERROR	Logical		Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
IFNA	Logical		Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression
IFS	Logical		Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
IMABS	Engineering		Returns the absolute value (modulus) of a complex number
IMAGINARY	Engineering		Returns the imaginary coefficient of a complex number
IMARGUMENT	Engineering		Returns the argument theta, an angle expressed in radians
IMCONJUGATE	Engineering		Returns the complex conjugate of a complex number
IMCOS	Engineering		Returns the cosine of a complex number
IMCOSH	Engineering		Returns the hyperbolic cosine of a complex number
IMCOT	Engineering		Returns the cotangent of a complex number
IMCSC	Engineering		Returns the cosecant of a complex number
IMCSCH	Engineering		Returns the hyperbolic cosecant of a complex number
IMDIV	Engineering		Returns the quotient of two complex numbers
IMEXP	Engineering		Returns the exponential of a complex number