# Alphabetical - S

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, Deprecated) 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 | (2021) The array of data in a range that has been sorted. |

SORTBY | (2021) The array of data in a range that has been sorted based on the values in a corresponding range. |

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. |

SUM | The total value of the numbers in a list, table or cell range. |

SUMIF | (SUMIFS) 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 | (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). |

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, Deprecated) 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(2021) The array of data in a range that has been sorted. |

SORTBY(2021) The array of data in a range that has been sorted based on the values in a corresponding range. |

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. |

SUMThe total value of the numbers in a list, table or cell range. |

SUMIF(SUMIFS) The 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(2019) The value based on a list of exact matches. |

SYDThe depreciation of an asset in a single period (sum-of-years digits method). |

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