Microsoft Office Development and Consultancy
 Home|

Excel

|VBA|C#|Finance|Tools|Newsletter|Feedback|Contact 
 Excel > Functions > S< Previous | Next > 

 ABCDEFGHIJKLMNOPQR

S

TUVWXYZ 
 
SEARCHThe position of a substring within a larger text string.
SEC(2013) The secant of an angle.
SECH(2013) The hyperbolic secant of an angle.
SECONDThe number of seconds given a date serial number.
SERIESSUM*The sum of a power series based on a formula.
SHEET(2013) The sheet number of the referenced sheet.
SHEETS(2013) The number of sheets in a reference.
SIGNThe numerical value indicating if a number is positive or negative.
SINThe sin of an angle in radians.
SINHThe hyperbolic sine of a number.
SKEWThe number representing the skewness of a distribution.
SKEW.P(2013) The skewness of a distribution based on a population.
SLNThe depreciation of an asset in a single period (straight-line method).
SLOPEThe slope of a linear regression line through the given data points.
SMALLThe Kth smallest value in a list or array of numbers.
SQL.REQUESTConnects to an external data source and executes a query.
SQRTThe positive square root of a number.
SQRTPI*The square root of a number multiplied by PI.
STANDARDIZEThe normalized value from a distributed characterised by a mean and a standard deviation.
STDEVThe standard deviation based on a sample.
STDEV.P(2010 - STDEVP) The standard deviation based on an entire population.
STDEV.S(2010 - STDEV) The standard deviation based on a sample.
STDEVAThe standard deviation based on a sample (including text and logical values).
STDEVPThe standard deviation based on an entire population.
STDEVPAThe standard deviation based on an entire population (including text and logical values).
STEYXThe standard error of a regression.
SUBSTITUTEThe text string with a substring substituted for another substring.
SUBTOTALThe subtotal of values in a list or database column.
SUMThe total value of the numbers in a list or cell range.
SUMIFThe total value of the numbers that satisfies a condition.
SUMIFS(2007) The total value of the numbers that satisfy multiple conditions.
SUMPRODUCTThe sum of the product of one or more arrays of values.
SUMSQThe sum of the squares of all the values in a list or cell range.
SUMX2MY2The sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2The sum of the sum of squares of corresponding values in two arrays.
SUMXMY2The sum of squares of differences of corresponding values in two arrays.
SYDThe depreciation of an asset in a single period (sum-of-years digits method).
 
 Note: * These are Analysis ToolPak functions in Excel 2003

 © 2013 Better Solutions Limited. All Rights Reserved.Top | 03-Jan-2013