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

EFFECT	Financial		Returns the effective annual interest rate
ENCODEURL	Web		Returns a URL-encoded string
EOMONTH	Date and time		Returns the serial number of the last day of the month before or after a specified number of months
ERF	Engineering		Returns the error function
ERF.PRECISE	Engineering		Returns the error function
ERFC	Engineering		Returns the complementary error function
ERFC.PRECISE	Engineering		Returns the complementary ERF function integrated between x and infinity
ERROR.TYPE	Information		Returns a number corresponding to an error type
EUROCONVERT	Add-in and Automation		Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation).
EVEN	Math and trigonometry		Rounds a number up to the nearest even integer
EXACT	Text		Checks to see if two text values are identical
EXP	Math and trigonometry		Returns raised to the power of a given number
EXPON.DIST	Statistical		Returns the exponential distribution
EXPONDIST	Compatibility		Returns the exponential distribution
F.DIST	Statistical		Returns the F probability distribution
F.DIST.RT	Statistical		Returns the F probability distribution
F.INV	Statistical		Returns the inverse of the F probability distribution
F.INV.RT	Statistical		Returns the inverse of the F probability distribution
F.TEST	Statistical		Returns the result of an F-test
FACT	Math and trigonometry		Returns the factorial of a number