Functions in 1997 (version 8.0)
332 built-in worksheet functions (237 + 95).
The Analysis ToolPak add-in contained 95 functions.
| ABS | The absolute value or a number without its sign. |
| ACCRINT | (Analysis ToolPak - Financial) The accrued interest for a security that pays interest periodically. |
| ACCRINTM | (Analysis ToolPak - Financial) The accrued interest for a security that pays interest at maturity. |
| ACOS | The arc-cosine of a number. |
| ACOSH | The hyperbolic arc-cosine of a number. |
| ADDRESS | The cell reference given a row and column number. |
| AMORDEGRC | (Analysis ToolPak - Financial) The depreciation of an asset in a single period (straight-line, implicit coefficient). |
| AMORLINC | (Analysis ToolPak - Financial) The depreciation of an asset in a single period (straight-line). |
| AND | The logical AND for any number of arguments. |
| AREAS | The number of areas in a cell range or reference. |
| ASC | (Analysis ToolPak - Text) The text string converted from double byte to single byte characters. |
| ASIN | The arc-sine of a number. |
| ASINH | The hyperbolic arc-sine of a number. |
| ATAN | The arc-tangent of a number. |
| ATAN2 | The arc-tangent of the specified x and y co-ordinates. |
| ATANH | The hyperbolic arc-tangent of a number. |
| AVEDEV | The average deviation of the numbers in a list, table or cell range. |
| AVERAGE | The arithmetic mean of non blank cells in a list, table or cell range. |
| AVERAGEA | The arithmetic mean of non blank cells in a list, table or cell range (including logical values and text). |
| BESSELI | (Analysis ToolPak - Engineering) The Bessel function evaluated for purely imaginary arguments. |
| BESSELJ | (Analysis ToolPak - Engineering) The modified Bessel function represented by J(x). |
| BESSELK | (Analysis ToolPak - Engineering) The modified Bessel function represented by K(x). |
| BESSELY | (Analysis ToolPak - Engineering) The modified Bessel function represented by Y(x). |
| BETADIST | (BETA.DIST) The cumulative probability function for a beta distribution (only cumulative). |
| BETAINV | (BETA.INV) The inverse of the probability distribution function for a beta distribution. |
| BIN2DEC | (Analysis ToolPak - Engineering) The number converted from binary to decimal. |
| BIN2HEX | (Analysis ToolPak - Engineering) The number converted from binary to hexadecimal. |
| BIN2OCT | (Analysis ToolPak - Engineering) The number converted from binary to octal. |
| BINOMDIST | (BINOM.DIST) The probability of getting a specific number of successes using a binomial distribution. |
| CALL | (Removed in 2003) The specification for a function or command using a registration ID. |
| CEILING | (CEILING.MATH) The number rounded up to the nearest integer or significant figure. |
| CELL | The text string indicating information about a cell. |
| CHAR | The character with the corresponding ANSI/ASCII number. |
| CHIDIST | (CHISQ.DIST.RT) The probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |
| CHIINV | (CHISQ.INV.RT) The inverse of the probability distribution function for a chi-squared distribution (right tailed). |
| CHITEST | (CHISQ.TEST) The probability value from a chi-squared distribution. |
| CHOOSE | The value in a row (or column) based on an index number. |
| CLEAN | The text string with all the non-printable characters removed. |
| CODE | The ANSI/ASCII number for the first character in a text string. |
| COLUMN | The column number of a cell reference. |
| COLUMNS | The number of columns in a cell range or reference. |
| COMBIN | The number of combinations for a given number of items (without repetition). |
| COMPLEX | (Analysis ToolPak - Engineering) The complex number given real and imaginary coefficients. |
| CONCATENATE | (CONCAT) The text string that is a concatenation of several strings. |
| CONFIDENCE | (CONFIDENCE.NORM) The confidence interval for a population mean. |
| CONVERT | (Analysis ToolPak - Engineering) The number in one measurement system converted to another. |
| CORREL | The correlation coefficient between two data sets. |
| COS | The cosine of a number. |
| COSH | The hyperbolic cosine of a number. |
| COUNT | The number of numerical values in a list, table or cell range. |
| COUNTA | The number of numerical values in a list, table or cell range (including logical values and text). |
| COUNTBLANK | The number of blank cells in a list, table or cell range. |
| COUNTIF | (COUNTIFS) The number of numerical values in a range that satisfies one condition. |
| COUPDAYBS | (Analysis ToolPak - Financial) The number of days between the previous coupon date and the settlement date. |
| COUPDAYS | (Analysis ToolPak - Financial) The number of days between the coupon dates on either side of the settlement date. |
| COUPDAYSNC | (Analysis ToolPak - Financial) The number of days between the settlement date and the next coupon date. |
| COUPNCD | (Analysis ToolPak - Financial) The next coupon date after the settlement date. |
| COUPNUM | (Analysis ToolPak - Financial) The number of coupons between the settlement date and the maturity date. |
| COUPPCD | (Analysis ToolPak - Financial) The previous coupon date before the settlement date. |
| COVAR | (COVARIANCE.P) The average of the products of deviations for each data point pair. |
| CRITBINOM | (BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed). |
| CUMIPMT | (Analysis ToolPak - Financial) The cumulative interest paid on a loan between two dates. |
| CUMPRINC | (Analysis ToolPak - Financial) The cumulative principal paid on a loan between two dates. |
| DATE | The date as a date serial number given a year, month, day. |
| DATEDIF | (Compatibility) The number of days, months or years between two dates. |
| DATEVALUE | The date serial number given a date in text format. |
| DAVERAGE | The arithmetic mean of non blank cells in a database column satisfying certain conditions. |
| DAY | The day as an integer given a date serial number. |
| DAYS360 | The number of days between two dates, based on 30 day months. |
| DB | The depreciation of an asset in a single period (declining balance method). |
| DCOUNT | The total number of non blank cells in a database column satisfying certain conditions. |
| DCOUNTA | The total number of non blank cells in a database column satisfying certain conditions (including logical values and text). |
| DDB | The depreciation of an asset in a single period (double or triple declining balance method). |
| DEC2BIN | (Analysis ToolPak - Engineering) The number converted from decimal to binary. |
| DEC2HEX | (Analysis ToolPak - Engineering) The number converted from decimal to hexadecimal. |
| DEC2OCT | (Analysis ToolPak - Engineering) The number converted from decimal to octal. |
| DEGREES | The number of degrees given a number of radians. |
| DELTA | (Analysis ToolPak - Engineering) The numerical value indicating if two numbers are equal. |
| DEVSQ | The sum of the squared deviations from the mean. |
| DGET | The single value in a database column satisfying certain conditions. |
| DISC | (Analysis ToolPak - Financial) The interest rate (or discount rate) for a security held to maturity. |
| DMAX | The maximum value in a database column satisfying certain conditions. |
| DMIN | The minimum value in a database column satisfying certain conditions. |
| DOLLAR | The text string of a number with the dollar formatting $0,000.00. |
| DOLLARDE | (Analysis ToolPak - Financial) The dollar fraction expressed as a decimal. |
| DOLLARFR | (Analysis ToolPak - Financial) The dollar decimal expressed as a fraction. |
| DPRODUCT | The product of values in a database column satisfying certain conditions. |
| DSTDEV | The standard deviation of a database column satisfying certain conditions based on a sample. |
| DSTDEVP | The standard deviation of a database column satisfying certain conditions based on an entire population. |
| DSUM | The sum of values in a database column satisfying certain conditions. |
| DURATION | (Analysis ToolPak - Financial) The annual duration of a security that pays interest periodically. |
| DVAR | The variance of a database column satisfying certain conditions based on a sample. |
| DVARP | The variance of a database column satisfying certain conditions based on an entire population. |
| EDATE | (Analysis ToolPak - Date & Time) The date serial number that is a certain number of months before or after a date. |
| EFFECT | (Analysis ToolPak - Financial) The effective interest rate given a nominal interest rate and compounding frequency. |
| EOMONTH | (Analysis ToolPak - Date & Time) The date serial number of the last day of a month before or after a date. |
| ERF | (Analysis ToolPak - Engineering) The value of the error function integrated between two limits. |
| ERFC | (Analysis ToolPak - Engineering) The complementary error function integrated between a limit and infinity. |
| ERROR.TYPE | The number corresponding to a particular error value in a cell. |
| EUROCONVERT | (Euro Currency Add-in) The number converted to euros. |
| EVEN | The number rounded up to the nearest even integer. |
| EXACT | The value True or False based on whether two strings match exactly. |
| EXP | The exponential number raised to a particular power. |
| EXPONDIST | (EXPON.DIST) The probability distribution function OR the cumulative probability function for an exponential distribution. |
| FACT | The factorial of a positive whole number. |
| FACTDOUBLE | (Analysis ToolPak - Maths & Trigonometry) The double factorial of a positive whole number. |
| FALSE | The logical value False. |
| FDIST | (F.DIST) The probability distribution function for an f distribution (left tailed) (no cumulative). |
| FIND | The starting position of a substring within a larger text string. |
| FINV | (F.INV) The inverse of the probability distribution function for an f distribution (left tailed). |
| FISHER | The fisher transformation. |
| FISHERINV | The inverse of the fisher transformation. |
| FIXED | The text string of a number rounded to a fixed number of decimal places. |
| FLOOR | (FLOOR.MATH) The number rounded down to the nearest integer or significant figure. |
| FORECAST | (FORECAST.LINEAR) The future y-value along a linear trend using existing values. |
| FREQUENCY | The number of times a particular value occurs in a list, table or cell range. |
| FTEST | (F.TEST) The probability value from an f distribution. |
| FV | The future value of a series of equal cash flows at regular intervals. |
| FVSCHEDULE | (Analysis ToolPak - Financial) The future value of an initial principal after applying compound interest rates. |
| GAMMADIST | (GAMMA.DIST) The probability distribution function OR the cumulative probability function for a gamma distribution. |
| GAMMAINV | (GAMMA.INV) The inverse of the probability distribution for a gamma distribution. |
| GAMMALN | (GAMMALN.PRECISE) The natural logarithm of the gamma function. |
| GCD | (Analysis ToolPak - Maths & Trigonometry) The greatest common divisor of two or more numbers. |
| GEOMEAN | The geometric mean of an array of numbers. |
| GESTEP | (Analysis ToolPak - Engineering) The value True or False depending if the number is greater than a threshold value. |
| GETPIVOTDATA | The data obtained from a pivot table. |
| GROWTH | The predicted exponential growth using existing data. |
| HARMEAN | The harmonic mean of a data set. |
| HEX2BIN | (Analysis ToolPak - Engineering) The number converted from hexadecimal to binary. |
| HEX2DEC | (Analysis ToolPak - Engineering) The number converted from hexadecimal to decimal. |
| HEX2OCT | (Analysis ToolPak - Engineering) The number converted from hexadecimal to octal. |
| HLOOKUP | The value in the same column after finding a matching value in the first row. |
| HOUR | The hour as an integer given a date serial number. |
| HYPERLINK | The hyperlink linked to a cell, document or webpage. |
| HYPGEOMDIST | (HYPGEOM.DIST) The cumulative probability function for a hypergeometric distribution (only cumulative). |
| IF | The value based on whether a condition is True or False. |
| IMABS | (Analysis ToolPak - Engineering) The absolute value of a complex number. |
| IMAGINARY | (Analysis ToolPak - Engineering) The imaginary coefficient of a complex number. |
| IMARGUMENT | (Analysis ToolPak - Engineering) The theta argument in radians. |
| IMCONJUGATE | (Analysis ToolPak - Engineering) The complex conjugate of a complex number. |
| IMCOS | (Analysis ToolPak - Engineering) The cosine of a complex number. |
| IMDIV | (Analysis ToolPak - Engineering) The quotient of two complex numbers. |
| IMEXP | (Analysis ToolPak - Engineering) The exponential of a complex number. |
| IMLN | (Analysis ToolPak - Engineering) The natural logarithm of a complex number. |
| IMLOG10 | (Analysis ToolPak - Engineering) The base-10 logarithm of a complex number. |
| IMLOG2 | (Analysis ToolPak - Engineering) The base-2 logarithm of a complex number. |
| IMPOWER | (Analysis ToolPak - Engineering) The complex number raised to an integer number. |
| IMPRODUCT | (Analysis ToolPak - Engineering) The product of two or more complex numbers. |
| IMREAL | (Analysis ToolPak - Engineering) The real coefficient of a complex number. |
| IMSIN | (Analysis ToolPak - Engineering) The sine of a complex number. |
| IMSQRT | (Analysis ToolPak - Engineering) The square root of a complex number. |
| IMSUB | (Analysis ToolPak - Engineering) The difference of two complex numbers. |
| IMSUM | (Analysis ToolPak - Engineering) The sum of two or more complex numbers. |
| INDEX | The value from a cell range which is the intersection of a row AND a column. |
| INDIRECT | The text string of the contents of a given cell reference. |
| INFO | The text string returning useful information about the environment. |
| INT | The number rounded down to the nearest integer. |
| INTERCEPT | The intersection with the y-axis using a linear regression plotted through known values. |
| INTRATE | (Analysis ToolPak - Financial) The interest rate for a security held to maturity. |
| IPMT | The interest amount paid on a given period on a loan with fixed interest. |
| IRR | The interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate). |
| ISBLANK | The boolean True or False depending if the value is blank. |
| ISERR | The boolean True or False depending if the value is an error (not #N/A). |
| ISERROR | The boolean True or False depending if the value is an error. |
| ISEVEN | (Analysis ToolPak - Information) The boolean True or False depending if the value is an even number. |
| ISLOGICAL | The boolean True or False depending if the value is True or False. |
| ISNA | The boolean True or False depending if the value is #N/A. |
| ISNONTEXT | The boolean True or False depending if the value is non text. |
| ISNUMBER | The boolean True or False depending if the value is a number. |
| ISODD | (Analysis ToolPak - Information) The boolean True or False depending if the value is an odd number. |
| ISPMT | (IPMT) The interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly). |
| ISREF | The boolean True or False depending if the value is a cell reference. |
| ISTEXT | The boolean True or False depending if the value is text. |
| KURT | The kurtosis for a list or array of numbers. |
| LARGE | The kth largest value in a list or array of numbers. |
| LCM | (Analysis ToolPak - Maths & Trigonometry) The least common multiple of two or more numbers. |
| LEFT | The first or left most characters in a text string. |
| LEN | The number of characters in a text string. |
| LINEST | The array of values for a straight line that best fits your data. |
| LN | The natural logarithm of a number. |
| LOG | The logarithm of a number to any base. |
| LOG10 | The logarithm of a number to the base 10. |
| LOGEST | The array of values for an exponential curve that best fits your data. |
| LOGINV | (LOGNORM.INV) The inverse of the probability distribution function for a lognormal distribution. |
| LOGNORMDIST | (LOGNORM.DIST) The cumulative probability function for a lognormal distribution (only cumulative). |
| LOOKUP | The value in a row (or column) that matches a value in a column (or row). |
| LOWER | The text string with all the characters converted to lowercase. |
| MATCH | The position of a value in a list, table or cell range. |
| MAX | The largest value in a list or array of numbers. |
| MAXA | The largest value in a list or array of numbers (including logical values and text). |
| MDETERM | The matrix determinant of an array. |
| MDURATION | (Analysis ToolPak - Financial) The modified duration for a security that pays interest periodically. |
| MEDIAN | The median value in a list or array of numbers. |
| MID | The characters from the middle of a text string. |
| MIN | The smallest value in a list or array of numbers. |
| MINA | The smallest value in a list or array of numbers (including logical values and text). |
| MINUTE | The minute as an integer given a date serial number. |
| MINVERSE | The inverse matrix of an array. |
| MIRR | The interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate). |
| MMULT | The matrix product of two arrays. |
| MOD | The remainder after division. |
| MODE | (MODE.SNGL) The value that occurs most frequently in a list or array of numbers. |
| MONTH | The month as an integer given a date serial number. |
| MROUND | (Analysis ToolPak - Maths & Trigonometry) The number rounded to the desired multiple. |
| MULTINOMIAL | (Analysis ToolPak - Maths & Trigonometry) The multinomial of a set of numbers in a list or cell range. |
| N | The value converted to a number. |
| NA | The error value #N/A. |
| NEGBINOMDIST | (NEGBINOM.DIST) The probability distribution function for a negative binomial distribution (no cumulative). |
| NETWORKDAYS | (Analysis ToolPak - Date & Time) The total number of working days between two dates excluding weekends and holidays. |
| NOMINAL | (Analysis ToolPak - Financial) The nominal interest rate over a period given an annual interest rate. |
| 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. |
| OCT2BIN | (Analysis ToolPak - Engineering) The number converted from octal to binary. |
| OCT2DEC | (Analysis ToolPak - Engineering) The number converted from octal to decimal. |
| OCT2HEX | (Analysis ToolPak - Engineering) The number converted from octal to hexadecimal. |
| ODD | The number rounded up to the nearest odd integer. |
| ODDFPRICE | (Analysis ToolPak - Financial) The price per $100 face value of a security with an odd first period. |
| ODDFYIELD | (Analysis ToolPak - Financial) The yield of a security with an odd first period. |
| ODDLPRICE | (Analysis ToolPak - Financial) The price per $100 face value of a security with an odd last period. |
| ODDLYIELD | (Analysis ToolPak - Financial) 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. |
| PEARSON | The pearson product moment correlation coefficient. |
| PERCENTILE | (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). |
| PERMUT | The number of permutations for a subset of objects or events. |
| PI | The number PI (3.141592). |
| PMT | (Analysis ToolPak - Financial) 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. |
| POWER | The number raised to a given power. |
| PPMT | The principal amount paid on a given period on a loan with fixed interest. |
| PRICE | (Analysis ToolPak - Financial) The price of a security that pays periodic interest. |
| PRICEDISC | (Analysis ToolPak - Financial) The price of a discounted security (no interest payments). |
| PRICEMAT | (Analysis ToolPak - Financial) 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). |
| QUOTIENT | (Analysis ToolPak - Maths & Trigonometry) The integer portion after division. |
| RADIANS | The number of radians given the number of degrees. |
| RAND | The random number >=0 and <1. |
| RANDBETWEEN | (Analysis ToolPak - Maths & Trigonometry) 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). |
| RATE | The interest rate for a series of equal cash flows at regular intervals. |
| RECEIVED | (Analysis ToolPak - Financial) The amount received at the end when a security is held to maturity. |
| 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 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. |
| RSQ | The square of pearson product moment correlation coefficient through data points in known y's and known x's. |
| SEARCH | The starting position of a substring within a larger text string. |
| SECOND | The number of seconds as an integer given a date serial number. |
| SERIESSUM | (Analysis ToolPak - Maths & Trigonometry) The sum of a power series based on a formula. |
| SIGN | The numerical value indicating if a number is positive or negative. |
| SIN | The sine of a number. |
| SINH | The hyperbolic sine of a number. |
| SKEW | The number representing the skewness of a distribution based on a sample. |
| 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. |
| 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 | (Analysis ToolPak - Maths & Trigonometry) 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. |
| 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 (renamed). |
| 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. |
| 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. |
| SYD | The depreciation of an asset in a single period (sum-of-years digits method). |
| T | The text string of the value given. |
| TAN | The tangent of a number. |
| TANH | The hyperbolic tangent of a number. |
| TBILLEQ | (Analysis ToolPak - Financial) The yield (bond-equivalent) for a treasury bill. |
| TBILLPRICE | (Analysis ToolPak - Financial) The price per $100 face value for a treasury bill. |
| TBILLYIELD | (Analysis ToolPak - Financial) 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. |
| 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 date 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 value from a t distribution. |
| TYPE | The number indicating the data type of the value. |
| UPPER | The text string with all the characters converted to uppercase. |
| VALUE | (NUMBERVALUE) The number that a text string represents (renamed). |
| VAR | (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. |
| WEEKDAY | The day of the week for a given date. |
| WEEKNUM | (Analysis ToolPak - Date & Time) 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. |
| WORKDAY | (Analysis ToolPak - Date & Time) The date serial number that is a given number of working days before or after a date. |
| XIRR | (Analysis ToolPak - Financial) The interest rate for a series of unequal cash flows at irregular intervals (implicit reinvestment rate). |
| XNPV | (Analysis ToolPak - Financial) The net present value of a series of unequal cash flows at irregular intervals. |
| YEAR | The year as an integer given a date serial number. |
| YEARFRAC | (Analysis ToolPak - Date & Time) The number of years as a decimal between two dates. |
| YIELD | (Analysis ToolPak - Financial) The interest rate (annual) for a series of equal cash flows at regular intervals. |
| YIELDDISC | (Analysis ToolPak - Financial) The interest rate (annual) for a discounted security (no interest payments). |
| YIELDMAT | (Analysis ToolPak - Financial) The interest rate (annual) for a security that pays interest at maturity. |
| ZTEST | (Z.TEST) The probability that the supplied hypothesized sample mean is greater than the mean of the supplied data values. |
| ABS The absolute value or a number without its sign. |
| ACCRINT (Analysis ToolPak - Financial) The accrued interest for a security that pays interest periodically. |
| ACCRINTM (Analysis ToolPak - Financial) The accrued interest for a security that pays interest at maturity. |
| ACOS The arc-cosine of a number. |
| ACOSH The hyperbolic arc-cosine of a number. |
| ADDRESS The cell reference given a row and column number. |
| AMORDEGRC (Analysis ToolPak - Financial) The depreciation of an asset in a single period (straight-line, implicit coefficient). |
| AMORLINC (Analysis ToolPak - Financial) The depreciation of an asset in a single period (straight-line). |
| AND The logical AND for any number of arguments. |
| AREAS The number of areas in a cell range or reference. |
| ASC (Analysis ToolPak - Text) The text string converted from double byte to single byte characters. |
| ASIN The arc-sine of a number. |
| ASINH The hyperbolic arc-sine of a number. |
| ATAN The arc-tangent of a number. |
| ATAN2 The arc-tangent of the specified x and y co-ordinates. |
| ATANH The hyperbolic arc-tangent of a number. |
| AVEDEV The average deviation of the numbers in a list, table or cell range. |
| AVERAGE The arithmetic mean of non blank cells in a list, table or cell range. |
| AVERAGEA The arithmetic mean of non blank cells in a list, table or cell range (including logical values and text). |
| BESSELI (Analysis ToolPak - Engineering) The Bessel function evaluated for purely imaginary arguments. |
| BESSELJ (Analysis ToolPak - Engineering) The modified Bessel function represented by J(x). |
| BESSELK (Analysis ToolPak - Engineering) The modified Bessel function represented by K(x). |
| BESSELY (Analysis ToolPak - Engineering) The modified Bessel function represented by Y(x). |
| BETADIST (BETA.DIST) The cumulative probability function for a beta distribution (only cumulative). |
| BETAINV (BETA.INV) The inverse of the probability distribution function for a beta distribution. |
| BIN2DEC (Analysis ToolPak - Engineering) The number converted from binary to decimal. |
| BIN2HEX (Analysis ToolPak - Engineering) The number converted from binary to hexadecimal. |
| BIN2OCT (Analysis ToolPak - Engineering) The number converted from binary to octal. |
| BINOMDIST (BINOM.DIST) The probability of getting a specific number of successes using a binomial distribution. |
| CALL (Removed in 2003) The specification for a function or command using a registration ID. |
| CEILING (CEILING.MATH) The number rounded up to the nearest integer or significant figure. |
| CELL The text string indicating information about a cell. |
| CHAR The character with the corresponding ANSI/ASCII number. |
| CHIDIST (CHISQ.DIST.RT) The probability distribution function for a chi-squared distribution (right tailed) (no cumulative). |
| CHIINV (CHISQ.INV.RT) The inverse of the probability distribution function for a chi-squared distribution (right tailed). |
| CHITEST (CHISQ.TEST) The probability value from a chi-squared distribution. |
| CHOOSE The value in a row (or column) based on an index number. |
| CLEAN The text string with all the non-printable characters removed. |
| CODE The ANSI/ASCII number for the first character in a text string. |
| COLUMN The column number of a cell reference. |
| COLUMNS The number of columns in a cell range or reference. |
| COMBIN The number of combinations for a given number of items (without repetition). |
| COMPLEX (Analysis ToolPak - Engineering) The complex number given real and imaginary coefficients. |
| CONCATENATE (CONCAT) The text string that is a concatenation of several strings. |
| CONFIDENCE (CONFIDENCE.NORM) The confidence interval for a population mean. |
| CONVERT (Analysis ToolPak - Engineering) The number in one measurement system converted to another. |
| CORREL The correlation coefficient between two data sets. |
| COS The cosine of a number. |
| COSH The hyperbolic cosine of a number. |
| COUNT The number of numerical values in a list, table or cell range. |
| COUNTA The number of numerical values in a list, table or cell range (including logical values and text). |
| COUNTBLANK The number of blank cells in a list, table or cell range. |
| COUNTIF (COUNTIFS) The number of numerical values in a range that satisfies one condition. |
| COUPDAYBS (Analysis ToolPak - Financial) The number of days between the previous coupon date and the settlement date. |
| COUPDAYS (Analysis ToolPak - Financial) The number of days between the coupon dates on either side of the settlement date. |
| COUPDAYSNC (Analysis ToolPak - Financial) The number of days between the settlement date and the next coupon date. |
| COUPNCD (Analysis ToolPak - Financial) The next coupon date after the settlement date. |
| COUPNUM (Analysis ToolPak - Financial) The number of coupons between the settlement date and the maturity date. |
| COUPPCD (Analysis ToolPak - Financial) The previous coupon date before the settlement date. |
| COVAR (COVARIANCE.P) The average of the products of deviations for each data point pair. |
| CRITBINOM (BINOM.INV) The inverse of the probability distribution function for a binomial distribution (renamed). |
| CUMIPMT (Analysis ToolPak - Financial) The cumulative interest paid on a loan between two dates. |
| CUMPRINC (Analysis ToolPak - Financial) The cumulative principal paid on a loan between two dates. |
| DATE The date as a date serial number given a year, month, day. |
| DATEDIF (Compatibility) The number of days, months or years between two dates. |
| DATEVALUE The date serial number given a date in text format. |
| DAVERAGE The arithmetic mean of non blank cells in a database column satisfying certain conditions. |
| DAY The day as an integer given a date serial number. |
| DAYS360 The number of days between two dates, based on 30 day months. |
| DB The depreciation of an asset in a single period (declining balance method). |
| DCOUNT The total number of non blank cells in a database column satisfying certain conditions. |
| DCOUNTA The total number of non blank cells in a database column satisfying certain conditions (including logical values and text). |
| DDB The depreciation of an asset in a single period (double or triple declining balance method). |
| DEC2BIN (Analysis ToolPak - Engineering) The number converted from decimal to binary. |
| DEC2HEX (Analysis ToolPak - Engineering) The number converted from decimal to hexadecimal. |
| DEC2OCT (Analysis ToolPak - Engineering) The number converted from decimal to octal. |
| DEGREES The number of degrees given a number of radians. |
| DELTA (Analysis ToolPak - Engineering) The numerical value indicating if two numbers are equal. |
| DEVSQ The sum of the squared deviations from the mean. |
| DGET The single value in a database column satisfying certain conditions. |
| DISC (Analysis ToolPak - Financial) The interest rate (or discount rate) for a security held to maturity. |
| DMAX The maximum value in a database column satisfying certain conditions. |
| DMIN The minimum value in a database column satisfying certain conditions. |
| DOLLAR The text string of a number with the dollar formatting $0,000.00. |
| DOLLARDE (Analysis ToolPak - Financial) The dollar fraction expressed as a decimal. |
| DOLLARFR (Analysis ToolPak - Financial) The dollar decimal expressed as a fraction. |
| DPRODUCT The product of values in a database column satisfying certain conditions. |
| DSTDEV The standard deviation of a database column satisfying certain conditions based on a sample. |
| DSTDEVP The standard deviation of a database column satisfying certain conditions based on an entire population. |
| DSUM The sum of values in a database column satisfying certain conditions. |
| DURATION (Analysis ToolPak - Financial) The annual duration of a security that pays interest periodically. |
| DVAR The variance of a database column satisfying certain conditions based on a sample. |
| DVARP The variance of a database column satisfying certain conditions based on an entire population. |
| EDATE (Analysis ToolPak - Date & Time) The date serial number that is a certain number of months before or after a date. |
| EFFECT (Analysis ToolPak - Financial) The effective interest rate given a nominal interest rate and compounding frequency. |
| EOMONTH (Analysis ToolPak - Date & Time) The date serial number of the last day of a month before or after a date. |
| ERF (Analysis ToolPak - Engineering) The value of the error function integrated between two limits. |
| ERFC (Analysis ToolPak - Engineering) The complementary error function integrated between a limit and infinity. |
| ERROR.TYPE The number corresponding to a particular error value in a cell. |
| EUROCONVERT (Euro Currency Add-in) The number converted to euros. |
| EVEN The number rounded up to the nearest even integer. |
| EXACT The value True or False based on whether two strings match exactly. |
| EXP The exponential number raised to a particular power. |
| EXPONDIST (EXPON.DIST) The probability distribution function OR the cumulative probability function for an exponential distribution. |
| FACT The factorial of a positive whole number. |
| FACTDOUBLE (Analysis ToolPak - Maths & Trigonometry) The double factorial of a positive whole number. |
| FALSE The logical value False. |
| FDIST (F.DIST) The probability distribution function for an f distribution (left tailed) (no cumulative). |
| FIND The starting position of a substring within a larger text string. |
| FINV (F.INV) The inverse of the probability distribution function for an f distribution (left tailed). |
| FISHER The fisher transformation. |
| FISHERINV The inverse of the fisher transformation. |
| FIXED The text string of a number rounded to a fixed number of decimal places. |
| FLOOR (FLOOR.MATH) The number rounded down to the nearest integer or significant figure. |
| FORECAST (FORECAST.LINEAR) The future y-value along a linear trend using existing values. |
| FREQUENCY The number of times a particular value occurs in a list, table or cell range. |
| FTEST (F.TEST) The probability value from an f distribution. |
| FV The future value of a series of equal cash flows at regular intervals. |
| FVSCHEDULE (Analysis ToolPak - Financial) The future value of an initial principal after applying compound interest rates. |
| GAMMADIST (GAMMA.DIST) The probability distribution function OR the cumulative probability function for a gamma distribution. |
| GAMMAINV (GAMMA.INV) The inverse of the probability distribution for a gamma distribution. |
| GAMMALN (GAMMALN.PRECISE) The natural logarithm of the gamma function. |
| GCD (Analysis ToolPak - Maths & Trigonometry) The greatest common divisor of two or more numbers. |
| GEOMEAN The geometric mean of an array of numbers. |
| GESTEP (Analysis ToolPak - Engineering) The value True or False depending if the number is greater than a threshold value. |
| GETPIVOTDATA The data obtained from a pivot table. |
| GROWTH The predicted exponential growth using existing data. |
| HARMEAN The harmonic mean of a data set. |
| HEX2BIN (Analysis ToolPak - Engineering) The number converted from hexadecimal to binary. |
| HEX2DEC (Analysis ToolPak - Engineering) The number converted from hexadecimal to decimal. |
| HEX2OCT (Analysis ToolPak - Engineering) The number converted from hexadecimal to octal. |
| HLOOKUP The value in the same column after finding a matching value in the first row. |
| HOUR The hour as an integer given a date serial number. |
| HYPERLINK The hyperlink linked to a cell, document or webpage. |
| HYPGEOMDIST (HYPGEOM.DIST) The cumulative probability function for a hypergeometric distribution (only cumulative). |
| IF The value based on whether a condition is True or False. |
| IMABS (Analysis ToolPak - Engineering) The absolute value of a complex number. |
| IMAGINARY (Analysis ToolPak - Engineering) The imaginary coefficient of a complex number. |
| IMARGUMENT (Analysis ToolPak - Engineering) The theta argument in radians. |
| IMCONJUGATE (Analysis ToolPak - Engineering) The complex conjugate of a complex number. |
| IMCOS (Analysis ToolPak - Engineering) The cosine of a complex number. |
| IMDIV (Analysis ToolPak - Engineering) The quotient of two complex numbers. |
| IMEXP (Analysis ToolPak - Engineering) The exponential of a complex number. |
| IMLN (Analysis ToolPak - Engineering) The natural logarithm of a complex number. |
| IMLOG10 (Analysis ToolPak - Engineering) The base-10 logarithm of a complex number. |
| IMLOG2 (Analysis ToolPak - Engineering) The base-2 logarithm of a complex number. |
| IMPOWER (Analysis ToolPak - Engineering) The complex number raised to an integer number. |
| IMPRODUCT (Analysis ToolPak - Engineering) The product of two or more complex numbers. |
| IMREAL (Analysis ToolPak - Engineering) The real coefficient of a complex number. |
| IMSIN (Analysis ToolPak - Engineering) The sine of a complex number. |
| IMSQRT (Analysis ToolPak - Engineering) The square root of a complex number. |
| IMSUB (Analysis ToolPak - Engineering) The difference of two complex numbers. |
| IMSUM (Analysis ToolPak - Engineering) The sum of two or more complex numbers. |
| INDEX The value from a cell range which is the intersection of a row AND a column. |
| INDIRECT The text string of the contents of a given cell reference. |
| INFO The text string returning useful information about the environment. |
| INT The number rounded down to the nearest integer. |
| INTERCEPT The intersection with the y-axis using a linear regression plotted through known values. |
| INTRATE (Analysis ToolPak - Financial) The interest rate for a security held to maturity. |
| IPMT The interest amount paid on a given period on a loan with fixed interest. |
| IRR The interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate). |
| ISBLANK The boolean True or False depending if the value is blank. |
| ISERR The boolean True or False depending if the value is an error (not #N/A). |
| ISERROR The boolean True or False depending if the value is an error. |
| ISEVEN (Analysis ToolPak - Information) The boolean True or False depending if the value is an even number. |
| ISLOGICAL The boolean True or False depending if the value is True or False. |
| ISNA The boolean True or False depending if the value is #N/A. |
| ISNONTEXT The boolean True or False depending if the value is non text. |
| ISNUMBER The boolean True or False depending if the value is a number. |
| ISODD (Analysis ToolPak - Information) The boolean True or False depending if the value is an odd number. |
| ISPMT (IPMT) The interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly). |
| ISREF The boolean True or False depending if the value is a cell reference. |
| ISTEXT The boolean True or False depending if the value is text. |
| KURT The kurtosis for a list or array of numbers. |
| LARGE The kth largest value in a list or array of numbers. |
| LCM (Analysis ToolPak - Maths & Trigonometry) The least common multiple of two or more numbers. |
| LEFT The first or left most characters in a text string. |
| LEN The number of characters in a text string. |
| LINEST The array of values for a straight line that best fits your data. |
| LN The natural logarithm of a number. |
| LOG The logarithm of a number to any base. |
| LOG10 The logarithm of a number to the base 10. |
| LOGEST The array of values for an exponential curve that best fits your data. |
| LOGINV (LOGNORM.INV) The inverse of the probability distribution function for a lognormal distribution. |
| LOGNORMDIST (LOGNORM.DIST) The cumulative probability function for a lognormal distribution (only cumulative). |
| LOOKUP The value in a row (or column) that matches a value in a column (or row). |
| LOWER The text string with all the characters converted to lowercase. |
| MATCH The position of a value in a list, table or cell range. |
| MAX The largest value in a list or array of numbers. |
| MAXA The largest value in a list or array of numbers (including logical values and text). |
| MDETERM The matrix determinant of an array. |
| MDURATION (Analysis ToolPak - Financial) The modified duration for a security that pays interest periodically. |
| MEDIAN The median value in a list or array of numbers. |
| MID The characters from the middle of a text string. |
| MIN The smallest value in a list or array of numbers. |
| MINA The smallest value in a list or array of numbers (including logical values and text). |
| MINUTE The minute as an integer given a date serial number. |
| MINVERSE The inverse matrix of an array. |
| MIRR The interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate). |
| MMULT The matrix product of two arrays. |
| MOD The remainder after division. |
| MODE (MODE.SNGL) The value that occurs most frequently in a list or array of numbers. |
| MONTH The month as an integer given a date serial number. |
| MROUND (Analysis ToolPak - Maths & Trigonometry) The number rounded to the desired multiple. |
| MULTINOMIAL (Analysis ToolPak - Maths & Trigonometry) The multinomial of a set of numbers in a list or cell range. |
| N The value converted to a number. |
| NA The error value #N/A. |
| NEGBINOMDIST (NEGBINOM.DIST) The probability distribution function for a negative binomial distribution (no cumulative). |
| NETWORKDAYS (Analysis ToolPak - Date & Time) The total number of working days between two dates excluding weekends and holidays. |
| NOMINAL (Analysis ToolPak - Financial) The nominal interest rate over a period given an annual interest rate. |
| 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. |
| OCT2BIN (Analysis ToolPak - Engineering) The number converted from octal to binary. |
| OCT2DEC (Analysis ToolPak - Engineering) The number converted from octal to decimal. |
| OCT2HEX (Analysis ToolPak - Engineering) The number converted from octal to hexadecimal. |
| ODD The number rounded up to the nearest odd integer. |
| ODDFPRICE (Analysis ToolPak - Financial) The price per $100 face value of a security with an odd first period. |
| ODDFYIELD (Analysis ToolPak - Financial) The yield of a security with an odd first period. |
| ODDLPRICE (Analysis ToolPak - Financial) The price per $100 face value of a security with an odd last period. |
| ODDLYIELD (Analysis ToolPak - Financial) 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. |
| PEARSON The pearson product moment correlation coefficient. |
| PERCENTILE (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). |
| PERMUT The number of permutations for a subset of objects or events. |
| PI The number PI (3.141592). |
| PMT (Analysis ToolPak - Financial) 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. |
| POWER The number raised to a given power. |
| PPMT The principal amount paid on a given period on a loan with fixed interest. |
| PRICE (Analysis ToolPak - Financial) The price of a security that pays periodic interest. |
| PRICEDISC (Analysis ToolPak - Financial) The price of a discounted security (no interest payments). |
| PRICEMAT (Analysis ToolPak - Financial) 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). |
| QUOTIENT (Analysis ToolPak - Maths & Trigonometry) The integer portion after division. |
| RADIANS The number of radians given the number of degrees. |
| RAND The random number >=0 and <1. |
| RANDBETWEEN (Analysis ToolPak - Maths & Trigonometry) 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). |
| RATE The interest rate for a series of equal cash flows at regular intervals. |
| RECEIVED (Analysis ToolPak - Financial) The amount received at the end when a security is held to maturity. |
| 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 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. |
| RSQ The square of pearson product moment correlation coefficient through data points in known y's and known x's. |
| SEARCH The starting position of a substring within a larger text string. |
| SECOND The number of seconds as an integer given a date serial number. |
| SERIESSUM (Analysis ToolPak - Maths & Trigonometry) The sum of a power series based on a formula. |
| SIGN The numerical value indicating if a number is positive or negative. |
| SIN The sine of a number. |
| SINH The hyperbolic sine of a number. |
| SKEW The number representing the skewness of a distribution based on a sample. |
| 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. |
| 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 (Analysis ToolPak - Maths & Trigonometry) 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. |
| 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 (renamed). |
| 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. |
| 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. |
| SYD The depreciation of an asset in a single period (sum-of-years digits method). |
| T The text string of the value given. |
| TAN The tangent of a number. |
| TANH The hyperbolic tangent of a number. |
| TBILLEQ (Analysis ToolPak - Financial) The yield (bond-equivalent) for a treasury bill. |
| TBILLPRICE (Analysis ToolPak - Financial) The price per $100 face value for a treasury bill. |
| TBILLYIELD (Analysis ToolPak - Financial) 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. |
| 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 date 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 value from a t distribution. |
| TYPE The number indicating the data type of the value. |
| UPPER The text string with all the characters converted to uppercase. |
| VALUE (NUMBERVALUE) The number that a text string represents (renamed). |
| VAR (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. |
| WEEKDAY The day of the week for a given date. |
| WEEKNUM (Analysis ToolPak - Date & Time) 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. |
| WORKDAY (Analysis ToolPak - Date & Time) The date serial number that is a given number of working days before or after a date. |
| XIRR (Analysis ToolPak - Financial) The interest rate for a series of unequal cash flows at irregular intervals (implicit reinvestment rate). |
| XNPV (Analysis ToolPak - Financial) The net present value of a series of unequal cash flows at irregular intervals. |
| YEAR The year as an integer given a date serial number. |
| YEARFRAC (Analysis ToolPak - Date & Time) The number of years as a decimal between two dates. |
| YIELD (Analysis ToolPak - Financial) The interest rate (annual) for a series of equal cash flows at regular intervals. |
| YIELDDISC (Analysis ToolPak - Financial) The interest rate (annual) for a discounted security (no interest payments). |
| YIELDMAT (Analysis ToolPak - Financial) The interest rate (annual) for a security that pays interest at maturity. |
| 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 TopPrevNext