Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft 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.
STDEVPThe standard deviation based on an entire population.
STDEVPAThe standard deviation based on an entire population.
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.
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

 Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top