Alphabetical N - Z
| N | The value converted to a number. |
| NA | The error value #N/A. |
| NEGBINOM.DIST | The probability distribution function OR the cumulative distribution function for a negative binomial distribution. |
| NEGBINOMDIST | (NEGBINOM.DIST) The probability distribution function for a negative binomial distribution (no cumulative). |
| NETWORKDAYS | (NETWORKDAYS.INTL) The total number of working days between two dates excluding weekends and holidays. |
| NETWORKDAYS.INTL | The total number of working days between two dates excluding weekends and holidays. |
| NOMINAL | The nominal interest rate over a period given an annual interest rate. |
| NORM.DIST | The probability distribution function OR the cumulative distribution function for a normal distribution. |
| NORM.INV | The inverse of the probability distribution function for a normal distribution. |
| NORM.S.DIST | The probability distribution function OR the cumulative distribution function for a standard normal distribution. |
| NORM.S.INV | The inverse of the probability distribution function for a standard normal distribution. |
| NORMDIST | (NORM.DIST) The probability distribution function OR the cumulative distribution function for a normal distribution. |
| NORMINV | (NORM.INV) The x variable corresponding to less than a particular probability. |
| NORMSDIST | (NORM.S.DIST) The probability distribution function for a normal distribution (no cumulative). |
| NORMSINV | (NORM.S.INV) The x variable corresponding to less than a particular probability. |
| NOT | The opposite of a True or False value. |
| NOW | The date serial number of the current system date and time. |
| NPER | The number of periods for an investment. |
| NPV | The net present value of a series of unequal cash flows at regular intervals. |
| NUMBERVALUE | (2013) The number that a text string represents (current locale). |
| OCT2BIN | The number converted from octal to binary. |
| OCT2DEC | The number converted from octal to decimal. |
| OCT2HEX | The number converted from octal to hexadecimal. |
| ODD | The number rounded up to the nearest odd integer. |
| ODDFPRICE | The price per $100 face value of a security with an odd first period. |
| ODDFYIELD | The yield of a security with an odd first period. |
| ODDLPRICE | The price per $100 face value of a security with an odd last period. |
| ODDLYIELD | The yield of a security with an odd last period. |
| OFFSET | The value in a cell which is an offset from another cell. |
| OR | The logical OR for any number of arguments. |
| PDURATION | (2013) The number of periods required by an investment to reach a specified value. |
| PEARSON | The pearson product moment correlation coefficient. |
| PERCENTILE | (PERCENTILE.INC) The number corresponding to a particular percentage from an array of numbers (inclusive). |
| PERCENTILE.EXC | The number corresponding to a particular percentage from an array of numbers (exclusive). |
| PERCENTILE.INC | The number corresponding to a particular percentage from an array of numbers (inclusive). |
| PERCENTRANK | (PERCENTRANK.INC) The percentage rank of a value in an array of numbers (inclusive). |
| PERCENTRANK.EXC | The percentage rank of a value in an array of numbers (exclusive). |
| PERCENTRANK.INC | The percentage rank of a value in an array of numbers (inclusive). |
| PERMUT | The number of permutations for a subset of objects or events. |
| PERMUTATIONA | (2013) The number of permutations for a subset of objects or events (with repetition). |
| PHI | (2013) The value of the density function for a standard normal distribution. |
| PHONETIC | The phonetic characters from a text string. |
| PI | The number PI (3.141592). |
| PMT | The full amount (principal + interest) paid every period on a loan with fixed interest. |
| POISSON | (POISSON.DIST) The probability distribution function OR the cumulative distribution function for a poisson distribution. |
| POISSON.DIST | The probability distribution function OR the cumulative distribution function for a poisson distribution. |
| POWER | The number raised to a given power. |
| PPMT | The principal amount paid on a given period on a loan with fixed interest. |
| PRICE | The price of a security that pays periodic interest. |
| PRICEDISC | The price of a discounted security (no interest payments). |
| PRICEMAT | The price of a security that pays interest at maturity. |
| PROB | The probability that values in a range are between two limits. |
| PRODUCT | The product of all the numbers in a list or cell range. |
| PROPER | The text string with the first letter of every word as a capital letter. |
| PV | The present value of a series of equal cash flows at regular intervals. |
| QUARTILE | (QUARTILE.INC) The quartile of a data set (inclusive). |
| QUARTILE.EXC | The quartile of a data set (exclusive). |
| QUARTILE.INC | The quartile of a data set (inclusive). |
| QUOTIENT | The integer portion after division. |
| RADIANS | The number of radians given the number of degrees. |
| RAND | The random number >=0 and <1. |
| RANDARRAY | (2021) The array of random numbers between 0 and 1. |
| RANDBETWEEN | The random number between two specified numbers (inclusive). |
| RANK | (RANK.EQ) The rank of a value in a list, table or cell range (in descending order) (equal ranking). |
| RANK.AVG | The rank of a value in a list, table or cell range (in descending order) (average ranking). |
| RANK.EQ | The rank of a value in a list, table or cell range (in descending order) (equal ranking). |
| RATE | The interest rate for a series of equal cash flows at regular intervals. |
| RECEIVED | The amount received at the end when a security is held to maturity. |
| REDUCE | (Microsoft 365) The total value after reducing an array by applying a LAMBDA function. |
| REGISTER | The registry ID for a specific DLL (dynamic linked library). |
| REGISTER.ID | The registry ID for a specific DLL (dynamic linked library). |
| REPLACE | The text string after replacing characters in a specific location. |
| REPT | The text string repeated a number of times. |
| RIGHT | The last or right most characters in a text string. |
| ROMAN | The text string converting a binary number to a roman numeral. |
| ROUND | The number rounded to a specified number of digits. |
| ROUNDDOWN | The number rounded down to the nearest integer. |
| ROUNDUP | The number rounded up to the nearest integer. |
| ROW | The row number of a cell reference. |
| ROWS | The number of rows in a cell range or reference. |
| RRI | (2013) The equivalent interest rate for the growth of an investment. |
| RSQ | The square of pearson product moment correlation coefficient through data points in known y's and known x's. |
| RTD | The real time data from a program that supports COM. |
| 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). |
| T | The text string of the value given. |
| T.DIST | The probability distribution function OR the cumulative distribution function for a t distribution (left tailed). |
| T.DIST.2T | The percentage points probability for the t distribution. |
| T.DIST.RT | The probability of getting greater than a particular value in a t distribution (right tailed). |
| T.INV | The probability of getting greater than a particular value in a t distribution (left tailed) |
| T.INV.2T | The t value of the t distribution as a function of the probability and the degrees of freedom. |
| T.TEST | The probability value from a T distribution. |
| TAKE | (Microsoft 365) The intersection of specific rows and columns in an array. |
| TAN | The tangent of a number. |
| TANH | The hyperbolic tangent of a number. |
| TBILLEQ | The yield (bond-equivalent) for a treasury bill. |
| TBILLPRICE | The price per $100 face value for a treasury bill. |
| TBILLYIELD | The yield for a treasury bill. |
| TDIST | (T.DIST.2T) The percentage points probability for the t distribution. |
| TEXT | The number as a formatted text string. |
| TEXTAFTER | (Microsoft 365) The characters from the end of a text string after a delimiter. |
| TEXTBEFORE | (Microsoft 365) The characters from the start of a text string before a delimiter. |
| TEXTJOIN | (2019) The text string that is a concatenation of several strings with a delimiter. |
| TEXTSPLIT | (Microsoft 365) The text string split into multiple columns using delimiters. |
| TIME | The time as a decimal given an hour, minute, second. |
| TIMEVALUE | The time as a decimal given a time in text format. |
| TINV | (T.INV.2T) The t-value of the distribution as a function of the probability and the degrees of freedom. |
| TOCOL | (Microsoft 365) The array transformed into a single column. |
| TODAY | The date serial number representing today's date. |
| TOROW | (Microsoft 365) The array transformed into a single row. |
| TRANSPOSE | The array with its orientation changed. |
| TREND | The y-values along a linear trend given a set of x-values. |
| TRIM | The text string with all extra spaces removed from the beginning, middle and end. |
| TRIMMEAN | The mean of the interior of a data set. |
| TRUE | The logical value True. |
| TRUNC | The number with any decimal places removed. |
| TTEST | (T.TEST) The probability value from a T distribution. |
| TYPE | The number indicating the data type of the value. |
| UNICHAR | (2013) The character with the corresponding UNICODE character. |
| UNICODE | (2013) The UNICODE number for the first character in a text string. |
| UNIQUE | (2021) The array of unique values in a list, table or cell range. |
| UPPER | The text string with all the characters converted to uppercase. |
| VALUE | (NUMBERVALUE) The number that a text string represents (renamed). |
| VALUETOTEXT | (Microsoft 365) The value converted to text. |
| VAR | (VAR.S) The variance based on a sample. |
| VAR.P | The variance based on an entire population. |
| VAR.S | The variance based on a sample. |
| VARA | The variance based on a sample (including logical values and text). |
| VARP | (VAR.P) The variance based on an entire population. |
| VARPA | The variance based on an entire population (including logical values and text). |
| VDB | The depreciation of an asset in a single period (variable declining balance method). |
| VLOOKUP | The value in the same row after finding a matching value in the first column. |
| VSTACK | (Microsoft 365) The array after putting multiple arrays on top of each other. |
| WEBSERVICE | (2013) The results from a webservice. |
| WEEKDAY | The day of the week for a given date. |
| WEEKNUM | The week number in the year for a given date. |
| WEIBULL | (WEIBULL.DIST) The probability distribution function OR the cumulative distribution function for a weibull distribution. |
| WEIBULL.DIST | The probability distribution function OR the cumulative distribution function for a weibull distribution. |
| WORKDAY | (WORKDAY.INTL) The date serial number that is a given number of working days before or after a date. |
| WORKDAY.INTL | The date serial number that is a given number of working days before or after a date. |
| WRAPCOLS | (Microsoft 365) The array transformed into multiple columns. |
| WRAPROWS | (Microsoft 365) The array transformed into multiple rows. |
| XIRR | The interest rate for a series of unequal cash flows at irregular intervals (implicit reinvestment rate). |
| XLOOKUP | (2021) The value in the same row after finding a matching value in any column. |
| XMATCH | (2021) The position of a value in a list, table or cell range. |
| XNPV | The net present value of a series of unequal cash flows at irregular intervals. |
| XOR | (2013) The logical exclusive OR for any number of arguments. |
| YEAR | The year as an integer given a date serial number. |
| YEARFRAC | The number of years as a decimal between two dates. |
| YIELD | The interest rate (annual) for a series of equal cash flows at regular intervals. |
| YIELDDISC | The interest rate (annual) for a discounted security (no interest payments). |
| YIELDMAT | The interest rate (annual) for a security that pays interest at maturity. |
| Z.TEST | The probability value from a Normal distribution. |
| ZTEST | (Z.TEST) The probability value from a Normal distribution. |
| N The value converted to a number. |
| NA The error value #N/A. |
| NEGBINOM.DIST The probability distribution function OR the cumulative distribution function for a negative binomial distribution. |
| NEGBINOMDIST (NEGBINOM.DIST) The probability distribution function for a negative binomial distribution (no cumulative). |
| NETWORKDAYS (NETWORKDAYS.INTL) The total number of working days between two dates excluding weekends and holidays. |
| NETWORKDAYS.INTL The total number of working days between two dates excluding weekends and holidays. |
| NOMINAL The nominal interest rate over a period given an annual interest rate. |
| NORM.DIST The probability distribution function OR the cumulative distribution function for a normal distribution. |
| NORM.INV The inverse of the probability distribution function for a normal distribution. |
| NORM.S.DIST The probability distribution function OR the cumulative distribution function for a standard normal distribution. |
| NORM.S.INV The inverse of the probability distribution function for a standard normal distribution. |
| NORMDIST (NORM.DIST) The probability distribution function OR the cumulative distribution function for a normal distribution. |
| NORMINV (NORM.INV) The x variable corresponding to less than a particular probability. |
| NORMSDIST (NORM.S.DIST) The probability distribution function for a normal distribution (no cumulative). |
| NORMSINV (NORM.S.INV) The x variable corresponding to less than a particular probability. |
| NOT The opposite of a True or False value. |
| NOW The date serial number of the current system date and time. |
| NPER The number of periods for an investment. |
| NPV The net present value of a series of unequal cash flows at regular intervals. |
| NUMBERVALUE (2013) The number that a text string represents (current locale). |
| OCT2BIN The number converted from octal to binary. |
| OCT2DEC The number converted from octal to decimal. |
| OCT2HEX The number converted from octal to hexadecimal. |
| ODD The number rounded up to the nearest odd integer. |
| ODDFPRICE The price per $100 face value of a security with an odd first period. |
| ODDFYIELD The yield of a security with an odd first period. |
| ODDLPRICE The price per $100 face value of a security with an odd last period. |
| ODDLYIELD The yield of a security with an odd last period. |
| OFFSET The value in a cell which is an offset from another cell. |
| OR The logical OR for any number of arguments. |
| PDURATION (2013) The number of periods required by an investment to reach a specified value. |
| PEARSON The pearson product moment correlation coefficient. |
| PERCENTILE (PERCENTILE.INC) The number corresponding to a particular percentage from an array of numbers (inclusive). |
| PERCENTILE.EXC The number corresponding to a particular percentage from an array of numbers (exclusive). |
| PERCENTILE.INC The number corresponding to a particular percentage from an array of numbers (inclusive). |
| PERCENTRANK (PERCENTRANK.INC) The percentage rank of a value in an array of numbers (inclusive). |
| PERCENTRANK.EXC The percentage rank of a value in an array of numbers (exclusive). |
| PERCENTRANK.INC The percentage rank of a value in an array of numbers (inclusive). |
| PERMUT The number of permutations for a subset of objects or events. |
| PERMUTATIONA (2013) The number of permutations for a subset of objects or events (with repetition). |
| PHI (2013) The value of the density function for a standard normal distribution. |
| PHONETIC The phonetic characters from a text string. |
| PI The number PI (3.141592). |
| PMT The full amount (principal + interest) paid every period on a loan with fixed interest. |
| POISSON (POISSON.DIST) The probability distribution function OR the cumulative distribution function for a poisson distribution. |
| POISSON.DIST The probability distribution function OR the cumulative distribution function for a poisson distribution. |
| POWER The number raised to a given power. |
| PPMT The principal amount paid on a given period on a loan with fixed interest. |
| PRICE The price of a security that pays periodic interest. |
| PRICEDISC The price of a discounted security (no interest payments). |
| PRICEMAT The price of a security that pays interest at maturity. |
| PROB The probability that values in a range are between two limits. |
| PRODUCT The product of all the numbers in a list or cell range. |
| PROPER The text string with the first letter of every word as a capital letter. |
| PV The present value of a series of equal cash flows at regular intervals. |
| QUARTILE (QUARTILE.INC) The quartile of a data set (inclusive). |
| QUARTILE.EXC The quartile of a data set (exclusive). |
| QUARTILE.INC The quartile of a data set (inclusive). |
| QUOTIENT The integer portion after division. |
| RADIANS The number of radians given the number of degrees. |
| RAND The random number >=0 and <1. |
| RANDARRAY (2021) The array of random numbers between 0 and 1. |
| RANDBETWEEN The random number between two specified numbers (inclusive). |
| RANK (RANK.EQ) The rank of a value in a list, table or cell range (in descending order) (equal ranking). |
| RANK.AVG The rank of a value in a list, table or cell range (in descending order) (average ranking). |
| RANK.EQ The rank of a value in a list, table or cell range (in descending order) (equal ranking). |
| RATE The interest rate for a series of equal cash flows at regular intervals. |
| RECEIVED The amount received at the end when a security is held to maturity. |
| REDUCE (Microsoft 365) The total value after reducing an array by applying a LAMBDA function. |
| REGISTER The registry ID for a specific DLL (dynamic linked library). |
| REGISTER.ID The registry ID for a specific DLL (dynamic linked library). |
| REPLACE The text string after replacing characters in a specific location. |
| REPT The text string repeated a number of times. |
| RIGHT The last or right most characters in a text string. |
| ROMAN The text string converting a binary number to a roman numeral. |
| ROUND The number rounded to a specified number of digits. |
| ROUNDDOWN The number rounded down to the nearest integer. |
| ROUNDUP The number rounded up to the nearest integer. |
| ROW The row number of a cell reference. |
| ROWS The number of rows in a cell range or reference. |
| RRI (2013) The equivalent interest rate for the growth of an investment. |
| RSQ The square of pearson product moment correlation coefficient through data points in known y's and known x's. |
| RTD The real time data from a program that supports COM. |
| 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). |
| T The text string of the value given. |
| T.DIST The probability distribution function OR the cumulative distribution function for a t distribution (left tailed). |
| T.DIST.2T The percentage points probability for the t distribution. |
| T.DIST.RT The probability of getting greater than a particular value in a t distribution (right tailed). |
| T.INV The probability of getting greater than a particular value in a t distribution (left tailed) |
| T.INV.2T The t value of the t distribution as a function of the probability and the degrees of freedom. |
| T.TEST The probability value from a T distribution. |
| TAKE (Microsoft 365) The intersection of specific rows and columns in an array. |
| TAN The tangent of a number. |
| TANH The hyperbolic tangent of a number. |
| TBILLEQ The yield (bond-equivalent) for a treasury bill. |
| TBILLPRICE The price per $100 face value for a treasury bill. |
| TBILLYIELD The yield for a treasury bill. |
| TDIST (T.DIST.2T) The percentage points probability for the t distribution. |
| TEXT The number as a formatted text string. |
| TEXTAFTER (Microsoft 365) The characters from the end of a text string after a delimiter. |
| TEXTBEFORE (Microsoft 365) The characters from the start of a text string before a delimiter. |
| TEXTJOIN (2019) The text string that is a concatenation of several strings with a delimiter. |
| TEXTSPLIT (Microsoft 365) The text string split into multiple columns using delimiters. |
| TIME The time as a decimal given an hour, minute, second. |
| TIMEVALUE The time as a decimal given a time in text format. |
| TINV (T.INV.2T) The t-value of the distribution as a function of the probability and the degrees of freedom. |
| TOCOL (Microsoft 365) The array transformed into a single column. |
| TODAY The date serial number representing today's date. |
| TOROW (Microsoft 365) The array transformed into a single row. |
| TRANSPOSE The array with its orientation changed. |
| TREND The y-values along a linear trend given a set of x-values. |
| TRIM The text string with all extra spaces removed from the beginning, middle and end. |
| TRIMMEAN The mean of the interior of a data set. |
| TRUE The logical value True. |
| TRUNC The number with any decimal places removed. |
| TTEST (T.TEST) The probability value from a T distribution. |
| TYPE The number indicating the data type of the value. |
| UNICHAR (2013) The character with the corresponding UNICODE character. |
| UNICODE (2013) The UNICODE number for the first character in a text string. |
| UNIQUE (2021) The array of unique values in a list, table or cell range. |
| UPPER The text string with all the characters converted to uppercase. |
| VALUE (NUMBERVALUE) The number that a text string represents (renamed). |
| VALUETOTEXT (Microsoft 365) The value converted to text. |
| VAR (VAR.S) The variance based on a sample. |
| VAR.P The variance based on an entire population. |
| VAR.S The variance based on a sample. |
| VARA The variance based on a sample (including logical values and text). |
| VARP (VAR.P) The variance based on an entire population. |
| VARPA The variance based on an entire population (including logical values and text). |
| VDB The depreciation of an asset in a single period (variable declining balance method). |
| VLOOKUP The value in the same row after finding a matching value in the first column. |
| VSTACK (Microsoft 365) The array after putting multiple arrays on top of each other. |
| WEBSERVICE (2013) The results from a webservice. |
| WEEKDAY The day of the week for a given date. |
| WEEKNUM The week number in the year for a given date. |
| WEIBULL (WEIBULL.DIST) The probability distribution function OR the cumulative distribution function for a weibull distribution. |
| WEIBULL.DIST The probability distribution function OR the cumulative distribution function for a weibull distribution. |
| WORKDAY (WORKDAY.INTL) The date serial number that is a given number of working days before or after a date. |
| WORKDAY.INTL The date serial number that is a given number of working days before or after a date. |
| WRAPCOLS (Microsoft 365) The array transformed into multiple columns. |
| WRAPROWS (Microsoft 365) The array transformed into multiple rows. |
| XIRR The interest rate for a series of unequal cash flows at irregular intervals (implicit reinvestment rate). |
| XLOOKUP (2021) The value in the same row after finding a matching value in any column. |
| XMATCH (2021) The position of a value in a list, table or cell range. |
| XNPV The net present value of a series of unequal cash flows at irregular intervals. |
| XOR (2013) The logical exclusive OR for any number of arguments. |
| YEAR The year as an integer given a date serial number. |
| YEARFRAC The number of years as a decimal between two dates. |
| YIELD The interest rate (annual) for a series of equal cash flows at regular intervals. |
| YIELDDISC The interest rate (annual) for a discounted security (no interest payments). |
| YIELDMAT The interest rate (annual) for a security that pays interest at maturity. |
| Z.TEST The probability value from a Normal distribution. |
| ZTEST (Z.TEST) The probability value from a Normal distribution. |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top