Alphabetical N - Z

NThe value converted to a number.
NAThe error value #N/A.
NEGBINOM.DIST(2010) The probability of getting less than or equal to a particular value in a negative binomial distribution.
NEGBINOMDIST(NEGBINOM.DIST) The probability of getting less than or equal to a particular value in a negative binomial distribution (no cumulative).
NETWORKDAYS(NETWORKDAYS.INTL) The total number of working days between two dates excluding weekends and holidays.
NETWORKDAYS.INTL(2010) The 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.DIST(2010) The probability of getting less than or equal to a particular value in a normal distribution.
NORM.INV(2010) The x variable corresponding to less than a particular probability.
NORM.S.DIST(2010) The probability of getting less than or equal to a particular value in a standard normal distribution.
NORM.S.INV(2010) The x variable corresponding to less than a particular probability.
NORMDIST(NORM.DIST) The probability of getting less than or equal to a particular value in a normal distribution.
NORMINV(NORM.INV) The x variable corresponding to less than a particular probability.
NORMSDIST(NORM.S.DIST) The probability of getting less than or equal to a particular value in a normal distribution (no cumulative).
NORMSINV(NORM.S.INV) The x variable corresponding to less than a particular probability.
NOTThe opposite of a True or False value.
NOWThe serial number of the current system date and time.
NPERThe number of periods for an investment.
NPVThe present value of a series of unequal cash flows at regular intervals.
NUMBERVALUE(2013) The 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 logical OR for any number of arguments.
PDURATION(2013) The number of periods required by an investment to reach a specified value.
PEARSONThe pearson product moment correlation coefficient.
PERCENTILE(PERCENTILE.INC) The number corresponding to a particular percentage from an array of numbers (inclusive).
PERCENTILE.EXC(2010) The number corresponding to a particular percentage from an array of numbers (exclusive).
PERCENTILE.INC(2010) 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(2010) The percentage rank of a value in an array of numbers (exclusive).
PERCENTRANK.INC(2010) The percentage rank of a value in an array of numbers (inclusive).
PERMUTThe 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.
PHONETICThe phonetic characters from a text string.
PIThe number PI (3.141592).
PMTThe payment for a loan with constant payments and fixed interest.
POISSON(POISSON.DIST) The probability of getting less than or equal to a particular value in a poisson distribution.
POISSON.DIST(2010) The probability of getting less than or equal to a particular value in a poisson distribution.
POWERThe number raised to a given power.
PPMTThe fixed payment made in each period of a series of equal cash flows at regular intervals.
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 values in a range are between two limits.
PRODUCTThe product of all the numbers in a list or cell range.
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.
QUARTILE(QUARTILE.INC) The quartile of a data set (inclusive).
QUARTILE.EXC(2010) The quartile of a data set (exclusive).
QUARTILE.INC(2010) The quartile of a data set (inclusive).
QUOTIENTThe integer portion after division.
RADIANSThe number of radians given the number of degrees.
RANDThe random number >=0 and <1.
RANDARRAY(2019) The array of random numbers between 0 and 1.
RANDBETWEENThe 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(2010) The rank of a value in a list, table or cell range (in descending order) (average ranking).
RANK.EQ(2010) The rank of a value in a list, table or cell range (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.
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 the nearest integer.
ROUNDUPThe number rounded up to the nearest integer.
ROWThe row number of a cell reference.
ROWSThe number of rows in a cell range or reference.
RRI(2013) The 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.
SEARCHThe position of a substring within a larger text string.
SEC(2013) The secant of a number.
SECH(2013) The hyperbolic secant of a number.
SECONDThe number of seconds as an integer given a date serial number.
SEQUENCE(2019) The array of sequential numbers.
SERIESSUMThe sum of a power series based on a formula.
SHEET(2013) The sheet number of the referenced sheet.
SHEETS(2013) The number of sheets in a reference.
SIGNThe numerical value indicating if a number is positive or negative.
SINThe sine of a number.
SINGLE(2019) The value from a cell range which is the intersection of a row OR a column.
SINHThe hyperbolic sine of a number.
SKEWThe number representing the skewness of a distribution based on a sample.
SKEW.P(2013) The number representing the skewness of a distribution based on an entire population.
SLNThe depreciation of an asset in a single period (straight-line method).
SLOPEThe slope of a linear regression line through the given data points.
SMALLThe kth smallest value in a list or array of numbers.
SORT(2019) The array of data in a range that has been sorted.
SORTBY(2019) The array of data in a range that has been sorted and satisfies multiple conditions.
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.P(2010) The standard deviation based on an entire population.
STDEV.S(2010) The 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.
SUBSTITUTEThe text string after replacing instances of a substring.
SUBTOTAL(AGGREGATE) The subtotal of values in a list, table or cell range.
SUMThe total value of the numbers in a list, table or cell range.
SUMIFThe total value of the numbers that satisfies one condition.
SUMIFSThe total value of the numbers that satisfies multiple conditions.
SUMPRODUCTThe sum of the product of one or more arrays of values.
SUMSQThe sum of the squares of all the values in a list, table or cell range.
SUMX2MY2The sum of the difference of squares of corresponding values in two arrays.
SUMX2PY2The sum of the sum of squares of corresponding values in two arrays.
SUMXMY2The sum of squares of differences of corresponding values in two arrays.
SWITCH(2016) The value based on the first matching item.
SYDThe depreciation of an asset in a single period (sum-of-years digits method).
TThe text string of the value given.
T.DIST(2010) The probability of getting less than or equal to a particular value in a t distribution (left tailed).
T.DIST.2T(2010) The percentage points probability for the t distribution.
T.DIST.RT(2010) The probability of getting greater than a particular value in a t distribution (right tailed).
T.INV(2010) The probability of getting greater than a particular value in a t distribution (left tailed)
T.INV.2T(2010) The t value of the t distribution as a function of the probability and the degrees of freedom.
T.TEST(2010) The probability associated with a t test.
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.
TEXTJOIN(2016) The text string that is a concatenation of several strings (with delimiter).
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.
TODAYThe serial number representing today's date.
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.
TRUEThe logical value True.
TRUNCThe number with any decimal places removed.
TTEST(T.TEST) The probability associated with a t test.
TYPEThe 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(2019) 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.
VAR(VAR.S) The variance based on a sample.
VAR.P(2010) The variance based on an entire population.
VAR.S(2010) The 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).
VLOOKUPThe value in the same row after finding a matching value in the first column.
WEBSERVICE(2013) The 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 of getting less than or equal to a particular value in a weibull distribution.
WEIBULL.DIST(2010) The probability of getting less than or equal to a particular value in a weibull distribution.
WORKDAY(WORKDAY.INTL) The serial number that is a given number of working days before or after a date.
WORKDAY.INTL(2010) The serial number that is a given number of working days before or after a date.
XIRRThe interest rate for a series of unequal cash flows at irregular intervals.
XNPVThe present value for a series of unequal cash flows at irregular intervals.
XOR(2013) The logical exclusive OR for any number of arguments.
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.TEST(2010) The two-tailed p-value of a z-test.
ZTEST(Z.TEST) The two-tailed p-value of a z-test.
N
The value converted to a number.
NA
The error value #N/A.
NEGBINOM.DIST
(2010) The probability of getting less than or equal to a particular value in a negative binomial distribution.
NEGBINOMDIST
(NEGBINOM.DIST) The probability of getting less than or equal to a particular value in a negative binomial distribution (no cumulative).
NETWORKDAYS
(NETWORKDAYS.INTL) The total number of working days between two dates excluding weekends and holidays.
NETWORKDAYS.INTL
(2010) 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
(2010) The probability of getting less than or equal to a particular value in a normal distribution.
NORM.INV
(2010) The x variable corresponding to less than a particular probability.
NORM.S.DIST
(2010) The probability of getting less than or equal to a particular value in a standard normal distribution.
NORM.S.INV
(2010) The x variable corresponding to less than a particular probability.
NORMDIST
(NORM.DIST) The probability of getting less than or equal to a particular value in a normal distribution.
NORMINV
(NORM.INV) The x variable corresponding to less than a particular probability.
NORMSDIST
(NORM.S.DIST) The probability of getting less than or equal to a particular value in 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 serial number of the current system date and time.
NPER
The number of periods for an investment.
NPV
The 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
(2010) The number corresponding to a particular percentage from an array of numbers (exclusive).
PERCENTILE.INC
(2010) 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
(2010) The percentage rank of a value in an array of numbers (exclusive).
PERCENTRANK.INC
(2010) 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 payment for a loan with constant payments and fixed interest.
POISSON
(POISSON.DIST) The probability of getting less than or equal to a particular value in a poisson distribution.
POISSON.DIST
(2010) The probability of getting less than or equal to a particular value in a poisson distribution.
POWER
The number raised to a given power.
PPMT
The fixed payment made in each period of a series of equal cash flows at regular intervals.
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
(2010) The quartile of a data set (exclusive).
QUARTILE.INC
(2010) 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
(2019) 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
(2010) The rank of a value in a list, table or cell range (in descending order) (average ranking).
RANK.EQ
(2010) 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.
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.
SEARCH
The 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
(2019) 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
(2019) 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
(2019) The array of data in a range that has been sorted.
SORTBY
(2019) The array of data in a range that has been sorted and satisfies multiple conditions.
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
(2010) The standard deviation based on an entire population.
STDEV.S
(2010) 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.
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
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
(2016) The value based on the first matching item.
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
(2010) The probability of getting less than or equal to a particular value in a t distribution (left tailed).
T.DIST.2T
(2010) The percentage points probability for the t distribution.
T.DIST.RT
(2010) The probability of getting greater than a particular value in a t distribution (right tailed).
T.INV
(2010) The probability of getting greater than a particular value in a t distribution (left tailed)
T.INV.2T
(2010) The t value of the t distribution as a function of the probability and the degrees of freedom.
T.TEST
(2010) The probability associated with a t test.
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.
TEXTJOIN
(2016) The text string that is a concatenation of several strings (with delimiter).
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.
TODAY
The serial number representing today's date.
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 associated with a t test.
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
(2019) 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.
VAR
(VAR.S) The variance based on a sample.
VAR.P
(2010) The variance based on an entire population.
VAR.S
(2010) 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.
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 of getting less than or equal to a particular value in a weibull distribution.
WEIBULL.DIST
(2010) The probability of getting less than or equal to a particular value in a weibull distribution.
WORKDAY
(WORKDAY.INTL) The serial number that is a given number of working days before or after a date.
WORKDAY.INTL
(2010) The serial number that is a given number of working days before or after a date.
XIRR
The interest rate for a series of unequal cash flows at irregular intervals.
XNPV
The present value for 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
(2010) The two-tailed p-value of a z-test.
ZTEST
(Z.TEST) The two-tailed p-value of a z-test.

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