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

SECOND	Date and time		Converts a serial number to a second
SERIESSUM	Math and trigonometry		Returns the sum of a power series based on the formula
SHEET	Information		Returns the sheet number of the referenced sheet
SHEETS	Information		Returns the number of sheets in a reference
SIGN	Math and trigonometry		Returns the sign of a number
SIN	Math and trigonometry		Returns the sine of the given angle
SINH	Math and trigonometry		Returns the hyperbolic sine of a number
SKEW	Statistical		Returns the skewness of a distribution
SKEW.P	Statistical		Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean
SLN	Financial		Returns the straight-line depreciation of an asset for one period
SLOPE	Statistical		Returns the slope of the linear regression line
SMALL	Statistical		Returns the k-th smallest value in a data set
SQL.REQUEST	Add-in and Automation		Connects with an external data source and runs a query from a worksheet, then returns the result as an array without the need for macro programming
SQRT	Math and trigonometry		Returns a positive square root
SQRTPI	Math and trigonometry		Returns the square root of (number * pi)
STANDARDIZE	Statistical		Returns a normalized value
STDEV	Compatibility		Estimates standard deviation based on a sample
STDEV.P	Statistical		Calculates standard deviation based on the entire population
STDEV.S	Statistical		Estimates standard deviation based on a sample
STDEVA	Statistical		Estimates standard deviation based on a sample, including numbers, text, and logical values