Alphabetical - S

SEARCHThe position of a substring within a larger text string.
SEC(2013) The secant of a number.
SECH(2013) The hyperbolic secant of a number.
SECONDThe number of seconds as an integer given a date serial number.
SEQUENCE(2019) The array of sequential numbers.
SERIESSUMThe 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 sine of a number.
SINGLE(2019) The value from a cell range which is the intersection of a row OR a column.
SINHThe hyperbolic sine of a number.
SKEWThe number representing the skewness of a distribution based on a sample.
SKEW.P(2013) The number representing the skewness of a distribution based on an entire 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.
SORT(2019) The array of data in a range that has been sorted.
SORTBY(2019) The array of data in a range that has been sorted and satisfies multiple conditions.
SQRTThe positive square root of a number.
SQRTPIThe square root of a number multiplied by PI.
STANDARDIZEThe normalized value from a distributed characterised by a mean and a standard deviation.
STDEV(STDEV.S) The standard deviation based on a sample.
STDEV.P(2010) The standard deviation based on an entire population.
STDEV.S(2010) The standard deviation based on a sample.
STDEVAThe standard deviation based on a sample (including logical values and text).
STDEVP(STDEV.P) The standard deviation based on an entire population.
STDEVPAThe standard deviation based on an entire population (including logical values and text).
STEYXThe standard error of a regression.
SUBSTITUTEThe text string after replacing instances of a substring.
SUBTOTAL(AGGREGATE) The subtotal of values in a list, table or cell range.
SUMThe total value of the numbers in a list, table or cell range.
SUMIFThe total value of the numbers that satisfies one condition.
SUMIFSThe total value of the numbers that satisfies 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, table 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.
SWITCH(2016) The value based on the first matching item.
SYDThe depreciation of an asset in a single period (sum-of-years digits method).
SEARCH
The position of a substring within a larger text string.
SEC
(2013) The secant of a number.
SECH
(2013) The hyperbolic secant of a number.
SECOND
The number of seconds as an integer given a date serial number.
SEQUENCE
(2019) The array of sequential numbers.
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.
SIGN
The numerical value indicating if a number is positive or negative.
SIN
The sine of a number.
SINGLE
(2019) The value from a cell range which is the intersection of a row OR a column.
SINH
The hyperbolic sine of a number.
SKEW
The number representing the skewness of a distribution based on a sample.
SKEW.P
(2013) The number representing the skewness of a distribution based on an entire population.
SLN
The depreciation of an asset in a single period (straight-line method).
SLOPE
The slope of a linear regression line through the given data points.
SMALL
The kth smallest value in a list or array of numbers.
SORT
(2019) The array of data in a range that has been sorted.
SORTBY
(2019) The array of data in a range that has been sorted and satisfies multiple conditions.
SQRT
The positive square root of a number.
SQRTPI
The square root of a number multiplied by PI.
STANDARDIZE
The normalized value from a distributed characterised by a mean and a standard deviation.
STDEV
(STDEV.S) The standard deviation based on a sample.
STDEV.P
(2010) The standard deviation based on an entire population.
STDEV.S
(2010) The standard deviation based on a sample.
STDEVA
The standard deviation based on a sample (including logical values and text).
STDEVP
(STDEV.P) The standard deviation based on an entire population.
STDEVPA
The standard deviation based on an entire population (including logical values and text).
STEYX
The standard error of a regression.
SUBSTITUTE
The text string after replacing instances of a substring.
SUBTOTAL
(AGGREGATE) The subtotal of values in a list, table or cell range.
SUM
The total value of the numbers in a list, table or cell range.
SUMIF
The total value of the numbers that satisfies one condition.
SUMIFS
The total value of the numbers that satisfies multiple conditions.
SUMPRODUCT
The sum of the product of one or more arrays of values.
SUMSQ
The sum of the squares of all the values in a list, table or cell range.
SUMX2MY2
The sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2
The sum of the sum of squares of corresponding values in two arrays.
SUMXMY2
The sum of squares of differences of corresponding values in two arrays.
SWITCH
(2016) The value based on the first matching item.
SYD
The depreciation of an asset in a single period (sum-of-years digits method).

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top