# 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 probability 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 probability 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 probability 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 probability function for a normal distribution. |

NORMINV | (NORM.INV) The inverse of the probability distribution function for a normal distribution. |

NORMSDIST | (NORM.S.DIST) The probability distribution function for a standard normal distribution (no cumulative). |

NORMSINV | (NORM.S.INV) The inverse of the probability distribution function for a standard normal distribution. |

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 | 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 boolean True or False depending on multiple conditions. |

PDURATION | The number of periods required by an investment to reach a specified value. |

PEARSON | The pearson product moment correlation coefficient. |

PERCENTILE | (PERCENTILE.INC) The value from a data set that corresponds to a particular percentage (inclusive). |

PERCENTILE.EXC | The value from a data set that corresponds to a particular percentage (exclusive). |

PERCENTILE.INC | The value from a data set that corresponds to a particular percentage (inclusive). |

PERCENTRANK | (PERCENTRANK.INC) The rank of a value as a percentage (inclusive). |

PERCENTRANK.EXC | The rank of a value as a percentage (exclusive). |

PERCENTRANK.INC | The rank of a value as a percentage (inclusive). |

PERMUT | The number of permutations for a subset of objects or events. |

PERMUTATIONA | The number of permutations for a subset of objects or events (with repetition). |

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

PIVOTBY | (2023) Preview. The grouping of your data along two axis and aggregates the associated values. |

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 probability function for a poisson distribution. |

POISSON.DIST | The probability distribution function OR the cumulative probability 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 the values in a data set are greater than a lower limit and less than an upper limit. |

PRODUCT | The product of all the numerical values. |

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

PY | (2023) New. The value or object after running code in a Python Editor using the Microsoft Cloud runtime. |

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 between zero and one (>=0 and <1). |

RANDARRAY | (2021) New. The array of random numbers between two values (>=min and <max). |

RANDBETWEEN | The random integer between two values (>=bottom and <=top). |

RANK | (RANK.EQ) The rank of a value in descending order (equal ranking). |

RANK.AVG | The rank of a value in descending order (average ranking). |

RANK.EQ | The rank of a value 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 | (2021) New. The total value after reducing an array by applying a LAMBDA function. |

REGEXEXTRACT | (2024) Preview. The characters that match a regular expression. |

REGEXREPLACE | (2024) Preview. The text string after replacing characters that match a regular expression. |

REGEXTEST | (2024) Preview. The boolean True or False depending if the regular expression matches any part of a text string. |

REGISTER.ID | (Removed in 2003) The result after running an Excel 4.0 Macro function. |

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 a specified number of digits. |

ROUNDUP | The number rounded up to a specified number of digits. |

ROW | The row number of a cell reference. |

ROWS | The number of rows in a cell range or reference. |

RRI | 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 | (2021) New. 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 (not case sensitive). |

SEC | The secant of a number. |

SECH | The hyperbolic secant of a number. |

SECOND | The number of seconds as an integer given a date serial number. |

SEQUENCE | (2021) New. The array of sequential numbers. |

SERIESSUM | The sum of a power series based on a formula. |

SHEET | The sheet number of the referenced sheet. |

SHEETS | 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 | 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 numerical value. |

SORT | (2021) New. The array of data that has been sorted by one column. |

SORTBY | (2021) New. The array of data that has been sorted based on multiple columns. |

SQL.REQUEST | (Removed in 2003) The result after connecting to a data source and executes a SQL query. |

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 | (2020) New. The historical data about a financial instrument. |

SUBSTITUTE | The text string after replacing instances of a substring. |

SUBTOTAL | (AGGREGATE) The choice of 11 different operations for numerical values (renamed). |

SUM | The total of the numerical values. |

SUMIF | (SUMIFS) The total of the numerical values that satisfies one condition. |

SUMIFS | The total of the numerical values 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) New. 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 for a t distribution (left tailed). |

T.DIST.2T | The probability distribution function for a two tailed distribution (no cumulative). |

T.DIST.RT | The probability distribution function for a t distribution (right tailed) (no cumulative). |

T.INV | The inverse of the probability distribution function for a t distribution (left tailed) |

T.INV.2T | The inverse of the probability distribution function for a two tailed distribution. |

T.TEST | The probability value from a t distribution. |

TAKE | (2022) New. 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 | (2022) New. The characters from the end of a text string after a delimiter. |

TEXTBEFORE | (2022) New. The characters from the start of a text string before a delimiter. |

TEXTJOIN | (2019) New. The text string that is a concatenation of several strings with a delimiter. |

TEXTSPLIT | (2022) New. 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 | (2022) New. The array transformed into a single column. |

TODAY | The date serial number representing today's date. |

TOROW | (2022) New. The array transformed into a single row. |

TRANSLATE | (2024) Preview. The text string translated into another language. |

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

TRIMRANGE | (2024) Preview. The array after excluding all empty rows and/or columns from the outer edges of a range. |

TRUE | (Compatibility) 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 | The character with the corresponding UNICODE character. |

UNICODE | The unicode number for the first character in a text string. |

UNIQUE | (2021) New. 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 | (2021) New. 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 | (XLOOKUP) The value in the same row after finding a matching value in the first column. |

VSTACK | (2021) New. The array after putting multiple arrays on top of each other. |

WEBSERVICE | 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 probability function for a weibull distribution. |

WEIBULL.DIST | The probability distribution function OR the cumulative probability 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 | (2022) New. The array transformed into multiple columns. |

WRAPROWS | (2022) New. 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) New. The value in the same row after finding a matching value in any column. |

XMATCH | (2021) New. 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 | The boolean True or False depending on multiple conditions. |

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 that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |

ZTEST | (Z.TEST) The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |

NThe value converted to a number. |

NAThe error value #N/A. |

NEGBINOM.DISTThe probability distribution function OR the cumulative probability 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.INTLThe total number of working days between two dates excluding weekends and holidays. |

NOMINALThe nominal interest rate over a period given an annual interest rate. |

NORM.DISTThe probability distribution function OR the cumulative probability function for a normal distribution. |

NORM.INVThe inverse of the probability distribution function for a normal distribution. |

NORM.S.DISTThe probability distribution function OR the cumulative probability function for a standard normal distribution. |

NORM.S.INVThe inverse of the probability distribution function for a standard normal distribution. |

NORMDIST(NORM.DIST) The probability distribution function OR the cumulative probability function for a normal distribution. |

NORMINV(NORM.INV) The inverse of the probability distribution function for a normal distribution. |

NORMSDIST(NORM.S.DIST) The probability distribution function for a standard normal distribution (no cumulative). |

NORMSINV(NORM.S.INV) The inverse of the probability distribution function for a standard normal distribution. |

NOTThe opposite of a True or False value. |

NOWThe date serial number of the current system date and time. |

NPERThe number of periods for an investment. |

NPVThe net present value of a series of unequal cash flows at regular intervals. |

NUMBERVALUEThe number that a text string represents (current locale). |

OCT2BINThe number converted from octal to binary. |

OCT2DECThe number converted from octal to decimal. |

OCT2HEXThe number converted from octal to hexadecimal. |

ODDThe number rounded up to the nearest odd integer. |

ODDFPRICEThe price per $100 face value of a security with an odd first period. |

ODDFYIELDThe yield of a security with an odd first period. |

ODDLPRICEThe price per $100 face value of a security with an odd last period. |

ODDLYIELDThe yield of a security with an odd last period. |

OFFSETThe value in a cell which is an offset from another cell. |

ORThe boolean True or False depending on multiple conditions. |

PDURATIONThe number of periods required by an investment to reach a specified value. |

PEARSONThe pearson product moment correlation coefficient. |

PERCENTILE(PERCENTILE.INC) The value from a data set that corresponds to a particular percentage (inclusive). |

PERCENTILE.EXCThe value from a data set that corresponds to a particular percentage (exclusive). |

PERCENTILE.INCThe value from a data set that corresponds to a particular percentage (inclusive). |

PERCENTRANK(PERCENTRANK.INC) The rank of a value as a percentage (inclusive). |

PERCENTRANK.EXCThe rank of a value as a percentage (exclusive). |

PERCENTRANK.INCThe rank of a value as a percentage (inclusive). |

PERMUTThe number of permutations for a subset of objects or events. |

PERMUTATIONAThe number of permutations for a subset of objects or events (with repetition). |

PHIThe value of the density function for a standard normal distribution. |

PHONETICThe phonetic characters from a text string. |

PIThe number PI (3.141592). |

PIVOTBY( 2023) Preview. The grouping of your data along two axis and aggregates the associated values. |

PMTThe full amount (principal + interest) paid every period on a loan with fixed interest. |

POISSON(POISSON.DIST) The probability distribution function OR the cumulative probability function for a poisson distribution. |

POISSON.DISTThe probability distribution function OR the cumulative probability function for a poisson distribution. |

POWERThe number raised to a given power. |

PPMTThe principal amount paid on a given period on a loan with fixed interest. |

PRICEThe price of a security that pays periodic interest. |

PRICEDISCThe price of a discounted security (no interest payments). |

PRICEMATThe price of a security that pays interest at maturity. |

PROBThe probability that the values in a data set are greater than a lower limit and less than an upper limit. |

PRODUCTThe product of all the numerical values. |

PROPERThe text string with the first letter of every word as a capital letter. |

PVThe present value of a series of equal cash flows at regular intervals. |

PY( 2023) New. The value or object after running code in a Python Editor using the Microsoft Cloud runtime. |

QUARTILE(QUARTILE.INC) The quartile of a data set (inclusive). |

QUARTILE.EXCThe quartile of a data set (exclusive). |

QUARTILE.INCThe quartile of a data set (inclusive). |

QUOTIENTThe integer portion after division. |

RADIANSThe number of radians given the number of degrees. |

RANDThe random number between zero and one (>=0 and <1). |

RANDARRAY( 2021) New. The array of random numbers between two values (>=min and <max). |

RANDBETWEENThe random integer between two values (>=bottom and <=top). |

RANK(RANK.EQ) The rank of a value in descending order (equal ranking). |

RANK.AVGThe rank of a value in descending order (average ranking). |

RANK.EQThe rank of a value in descending order (equal ranking). |

RATEThe interest rate for a series of equal cash flows at regular intervals. |

RECEIVEDThe amount received at the end when a security is held to maturity. |

REDUCE( 2021) New. The total value after reducing an array by applying a LAMBDA function. |

REGEXEXTRACT( 2024) Preview. The characters that match a regular expression. |

REGEXREPLACE( 2024) Preview. The text string after replacing characters that match a regular expression. |

REGEXTEST( 2024) Preview. The boolean True or False depending if the regular expression matches any part of a text string. |

REGISTER.ID(Removed in 2003) The result after running an Excel 4.0 Macro function. |

REPLACEThe text string after replacing characters in a specific location. |

REPTThe text string repeated a number of times. |

RIGHTThe last or right most characters in a text string. |

ROMANThe text string converting a binary number to a roman numeral. |

ROUNDThe number rounded to a specified number of digits. |

ROUNDDOWNThe number rounded down to a specified number of digits. |

ROUNDUPThe number rounded up to a specified number of digits. |

ROWThe row number of a cell reference. |

ROWSThe number of rows in a cell range or reference. |

RRIThe equivalent interest rate for the growth of an investment. |

RSQThe square of pearson product moment correlation coefficient through data points in known y's and known x's. |

RTDThe real time data from a program that supports COM. |

SCAN( 2021) New. 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 (not case sensitive). |

SECThe secant of a number. |

SECHThe hyperbolic secant of a number. |

SECONDThe number of seconds as an integer given a date serial number. |

SEQUENCE( 2021) New. The array of sequential numbers. |

SERIESSUMThe sum of a power series based on a formula. |

SHEETThe sheet number of the referenced sheet. |

SHEETSThe 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.PThe 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 numerical value. |

SORT( 2021) New. The array of data that has been sorted by one column. |

SORTBY( 2021) New. The array of data that has been sorted based on multiple columns. |

SQL.REQUEST(Removed in 2003) The result after connecting to a data source and executes a SQL query. |

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( 2020) New. The historical data about a financial instrument. |

SUBSTITUTEThe text string after replacing instances of a substring. |

SUBTOTAL(AGGREGATE) The choice of 11 different operations for numerical values (renamed). |

SUMThe total of the numerical values. |

SUMIF(SUMIFS) The total of the numerical values that satisfies one condition. |

SUMIFSThe total of the numerical values 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) New. The value based on a list of exact matches. |

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

TThe text string of the value given. |

T.DISTThe probability distribution function for a t distribution (left tailed). |

T.DIST.2TThe probability distribution function for a two tailed distribution (no cumulative). |

T.DIST.RTThe probability distribution function for a t distribution (right tailed) (no cumulative). |

T.INVThe inverse of the probability distribution function for a t distribution (left tailed) |

T.INV.2TThe inverse of the probability distribution function for a two tailed distribution. |

T.TESTThe probability value from a t distribution. |

TAKE( 2022) New. The intersection of specific rows and columns in an array. |

TANThe tangent of a number. |

TANHThe hyperbolic tangent of a number. |

TBILLEQThe yield (bond-equivalent) for a treasury bill. |

TBILLPRICEThe price per $100 face value for a treasury bill. |

TBILLYIELDThe yield for a treasury bill. |

TDIST(T.DIST.2T) The percentage points probability for the t distribution. |

TEXTThe number as a formatted text string. |

TEXTAFTER( 2022) New. The characters from the end of a text string after a delimiter. |

TEXTBEFORE( 2022) New. The characters from the start of a text string before a delimiter. |

TEXTJOIN( 2019) New. The text string that is a concatenation of several strings with a delimiter. |

TEXTSPLIT( 2022) New. The text string split into multiple columns using delimiters. |

TIMEThe time as a decimal given an hour, minute, second. |

TIMEVALUEThe 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( 2022) New. The array transformed into a single column. |

TODAYThe date serial number representing today's date. |

TOROW( 2022) New. The array transformed into a single row. |

TRANSLATE( 2024) Preview. The text string translated into another language. |

TRANSPOSEThe array with its orientation changed. |

TRENDThe y-values along a linear trend given a set of x-values. |

TRIMThe text string with all extra spaces removed from the beginning, middle and end. |

TRIMMEANThe mean of the interior of a data set. |

TRIMRANGE( 2024) Preview. The array after excluding all empty rows and/or columns from the outer edges of a range. |

TRUE(Compatibility) The logical value True. |

TRUNCThe number with any decimal places removed. |

TTEST(T.TEST) The probability value from a t distribution. |

TYPEThe number indicating the data type of the value. |

UNICHARThe character with the corresponding UNICODE character. |

UNICODEThe unicode number for the first character in a text string. |

UNIQUE( 2021) New. The array of unique values in a list, table or cell range. |

UPPERThe text string with all the characters converted to uppercase. |

VALUE(NUMBERVALUE) The number that a text string represents (renamed). |

VALUETOTEXT( 2021) New. The value converted to text. |

VAR(VAR.S) The variance based on a sample. |

VAR.PThe variance based on an entire population. |

VAR.SThe variance based on a sample. |

VARAThe variance based on a sample (including logical values and text). |

VARP(VAR.P) The variance based on an entire population. |

VARPAThe variance based on an entire population (including logical values and text). |

VDBThe depreciation of an asset in a single period (variable declining balance method). |

VLOOKUP(XLOOKUP) The value in the same row after finding a matching value in the first column. |

VSTACK( 2021) New. The array after putting multiple arrays on top of each other. |

WEBSERVICEThe results from a webservice. |

WEEKDAYThe day of the week for a given date. |

WEEKNUMThe week number in the year for a given date. |

WEIBULL(WEIBULL.DIST) The probability distribution function OR the cumulative probability function for a weibull distribution. |

WEIBULL.DISTThe probability distribution function OR the cumulative probability 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.INTLThe date serial number that is a given number of working days before or after a date. |

WRAPCOLS( 2022) New. The array transformed into multiple columns. |

WRAPROWS( 2022) New. The array transformed into multiple rows. |

XIRRThe interest rate for a series of unequal cash flows at irregular intervals (implicit reinvestment rate). |

XLOOKUP( 2021) New. The value in the same row after finding a matching value in any column. |

XMATCH( 2021) New. The position of a value in a list, table or cell range. |

XNPVThe net present value of a series of unequal cash flows at irregular intervals. |

XORThe boolean True or False depending on multiple conditions. |

YEARThe year as an integer given a date serial number. |

YEARFRACThe number of years as a decimal between two dates. |

YIELDThe interest rate (annual) for a series of equal cash flows at regular intervals. |

YIELDDISCThe interest rate (annual) for a discounted security (no interest payments). |

YIELDMATThe interest rate (annual) for a security that pays interest at maturity. |

Z.TESTThe probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |

ZTEST(Z.TEST) The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |

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