Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Functions > S< Previous | Next > 

 ABCDEFGHIJKLMNOPQR

S

TUVWXYZ 
 
SEARCHThe position of a substring within a larger text string.
SECONDThe number of seconds given a date serial number.
SERIESSUM*The sum of a power series based on a formula.
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.
SLNThe depreciation of an asset using the straight line method.
SLOPEThe slope of a linear regression line through the given data points.
SMALLThe Kth smallest value in an 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.
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 the predicted y-value for each x 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.
SUMIFSThe 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 using the sum of years method.
 
 Note: * These are Analysis ToolPak functions in Excel 2003

 Copyright © 2010 Better Solutions Limited. All Rights Reserved.Top