Alphabetical N - Z

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

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