Alphabetical - S

SCAN(Microsoft 365) The array after applying a LAMBDA function to each value and returns an array.
SEARCHThe starting 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(2021) 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(2021, Removed in 365) 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, table or cell range.
SORT(2021) The array of data that has been sorted by one column.
SORTBY(2021) The array of data that has been sorted based on multiple columns.
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.PThe standard deviation based on an entire population.
STDEV.SThe 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.
STOCKHISTORY(Microsoft 365) The historical data about a financial instrument.
SUBSTITUTEThe text string after replacing instances of a substring.
SUBTOTAL(AGGREGATE) The subtotal of values in a list, table or cell range (renamed).
SUMThe total of the numerical values in a list, table or cell range.
SUMIF(SUMIFS) The total of the numerical values in a list, table or cell range that satisfies one condition.
SUMIFSThe total of the numerical values in a list, table or cell range that satisfies multiple conditions.
SUMPRODUCTThe sum of the product of one or more arrays of values.
SUMSQThe variation of a data set from its mean.
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(2019) The value based on a list of exact matches.
SYDThe depreciation of an asset in a single period (sum-of-years digits method).
SCAN
(Microsoft 365) The array after applying a LAMBDA function to each value and returns an array.
SEARCH
The starting 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
(2021) 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
(2021, Removed in 365) 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, table or cell range.
SORT
(2021) The array of data that has been sorted by one column.
SORTBY
(2021) The array of data that has been sorted based on multiple columns.
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
The standard deviation based on an entire population.
STDEV.S
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.
STOCKHISTORY
(Microsoft 365) The historical data about a financial instrument.
SUBSTITUTE
The text string after replacing instances of a substring.
SUBTOTAL
(AGGREGATE) The subtotal of values in a list, table or cell range (renamed).
SUM
The total of the numerical values in a list, table or cell range.
SUMIF
(SUMIFS) The total of the numerical values in a list, table or cell range that satisfies one condition.
SUMIFS
The total of the numerical values in a list, table or cell range that satisfies multiple conditions.
SUMPRODUCT
The sum of the product of one or more arrays of values.
SUMSQ
The variation of a data set from its mean.
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
(2019) The value based on a list of exact matches.
SYD
The depreciation of an asset in a single period (sum-of-years digits method).

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