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, 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 or array of numbers. |
SORT | (2021) The array of data in a range that has been sorted by one column. |
SORTBY | (2021) The array of data in a range that has been sorted based on multiple columns or values in a 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 (renamed). |
SUM | The total of the values in a list, range or array. |
SUMIF | (SUMIFS) The total of the values that satisfies one condition. |
SUMIFS | The total of the values 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. |
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 or array of numbers. |
SORT (2021) The array of data in a range that has been sorted by one column. |
SORTBY (2021) The array of data in a range that has been sorted based on multiple columns or values in a 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 (renamed). |
SUM The total of the values in a list, range or array. |
SUMIF (SUMIFS) The total of the values that satisfies one condition. |
SUMIFS The total of the values 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). |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top