Excel 2007 features French-English
Check out our new Excel training courses in Brussels via TalentWire House Training
You can use the search function (CTRL + F) to find a specific function.
Function | Function | Description |
complement and automation | Add-in and Automation functions | |
FONCTION.APPELANTE | CALL | Calls a procedure in the dynamic link library or code resource. |
EUROCONVERT | EUROCONVERT | Converts a number to euros, converts a number into a euro currency in the European area or converts a number expressed in a currency of the European zone into another, using the euro as an intermediary (triangulation). |
GETPIVOTDATA | GETPIVOTDATA | Returns data stored in a PivotTable report. |
REGISTRE.NUMERO | REGISTER.ID | Returns the register ID of the dynamic link library that was specified or code resource that has been previously set registry. |
SQL.REQUEST | SQL.REQUEST | Connects to an external data source, runs a query from a worksheet, then returns the result as a matrix, without the need to program a macro. |
Cube functions | cube functions | |
MEMBREKPICUBE | CUBEKPIMEMBER | Returns a name, a property and a measure of KPI and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit margin or quarterly employee turnover, used to evaluate the performance of a company. |
MEMBRECUBE | CUBEMEMBER | Returns a member or tuple in a cube hierarchy. Use this to validate the existence of the member or tuple in the cube. |
PROPRIETEMEMBRECUBE | CUBEMEMBERPROPERTY | Returns the value of a member property of the cube. Use this to validate the existence of a member name in the cube and to return the specified property for this member. |
CUBERANKEDMEMBER | CUBERANKEDMEMBER | Returns the nth member or the member placed in a row in a set. Use to return one or more elements of a set, such as top sellers or top 10 students. |
JEUCUBE | CUBESET | Defines a calculated set of members or tuples by sending a defined term to the cube on the server that creates all and returns it to Microsoft Office Excel. |
NBJEUCUBE | CUBESETCOUNT | Returns the number of elements in a game. |
VALEURCUBE | CUBEVALUE | Returns a result aggregate value of a cube. |
Database functions | Database functions | |
DAVERAGE | DAVERAGE | Returns the average of selected database entries. |
BCOMPTE | DCOUNT | Counts the number of cells in a database that contain numbers. |
DCOUNTA | DCOUNTA | In the non-empty cells in a database. |
DGET | DGET | Extract from a database a single record that meets the specified criteria. |
DMAX | DMAX | Returns the maximum value of the selected database entries. |
DMIN | DMIN | Returns the minimum value of the selected database entries. |
DPRODUCT | DPRODUCT | Multiplies the values of a particular field of records in a database that meet specified criteria. |
DSTDEV | DSTDEV | Calculates the standard deviation for a sample of basic inputs of selected data. |
DSTDEVP | DSTDEVP | Calculates the standard deviation for the entire population of selected database entries. |
DSUM | DSUM | Adds the numbers in the record field column in the database that match the criteria. |
DVAR | PSUs | Calculates the variance for a sample of database entries of selected data. |
DVARP | DVARP | Calculates the variance for an entire population of selected database entries. |
Date and Time Functions | Date and time functions | |
DATED | DATED | Returns the serial number of a particular date. |
DATEVALUE | DATEVALUE | Converts a date represented in text form serial number. |
DAY | DAY | Converts a serial number in the month. |
DAYS360 | DAYS360 | Calculates the number of days between two dates based on a year of 360 days. |
EDATE | EDATE | Returns the serial number of the date that represents a specified date (the start_date argument), corrected or down the specified number of months. |
EOMONTH | EOMONTH | Returns the sequential number of the last day of the month before or after the start_date the specified number of months. |
HOUR | HOUR | Converts a serial number to an hour. |
MINUTE | MINUTE | Converts a serial number to a minute. |
MONTH | MONTH | Converts a serial number to a month. |
NETWORKDAYS | NETWORKDAYS | Returns the number of whole working days between two dates. |
NOW | NOW | Returns the serial number of the date and time of day. |
SECOND | SECOND | Converts a serial number to a second. |
TIME | TIME | Returns the serial number of a particular time. |
TIMEVALUE | TIMEVALUE | Converts a date represented in text form serial number. |
TODAY | TODAY | Returns the serial number of the current date. |
WEEKDAY | WEEKDAY | Converts a serial number to a day of the week. |
WEEKNUM | WEEKNUM | Converts a serial number to a number representing the order of the week in the year. |
workdays | WORKDAY | Returns the serial number of the date before or after the specified number of working days. |
YEAR | YEAR | Converts a serial number to a year. |
YEARFRAC | YEARFRAC | Returns the portion of the year is the number of days between the start date and end date. |
Engineering Functions | Engineering functions | |
BESSELI | BESSELI | Returns the modified Bessel function In (x). |
BESSELJ | BESSELJ | Returns the Bessel function Jn (x). |
BESSELK | BESSELK | Returns the modified Bessel function Kn (x). |
BESSELY | BESSELY | Returns the Bessel function Yn (x). |
bindec | BIN2DEC | Converts a binary number to decimal. |
BINHEX | BIN2HEX | Converts a binary number to hexadecimal number. |
BINOCT | BIN2OCT | Converts a binary number to octal. |
COMPLEX | COMPLEX | Converts real and imaginary coefficients into a complex number. |
CONVERT | CONVERT | Converts a number of a unit of measurement to another. |
decbin | DEC2BIN | Converts a decimal to binary number. |
dechex | DEC2HEX | Converts a decimal to hexadecimal number. |
decoct | DEC2OCT | Converts a decimal number to octal. |
DELTA | DELTA | Tests the equality of two numbers. |
ERF | ERF | Returns the value of the error function. |
ERFC | ERFC | Returns the value of the complementary error function. |
GESTEP | GESTEP | Test if a number is greater than a threshold value. |
hexbin | HEX2BIN | Converts a hexadecimal number to binary number. |
hexdec | HEX2DEC | Converts a hexadecimal number to decimal. |
HEXOCT | HEX2OCT | Converts a hexadecimal number to octal. |
IMABS | IMABS | Returns the absolute value (modulus) of a complex number. |
IMAGINARY | IMAGINARY | Returns the imaginary coefficient of a complex number. |
IMARGUMENT | IMARGUMENT | Returns the argument theta, an angle expressed in radians. |
IMCONJUGATE | IMCONJUGATE | Returns the complex conjugate of a complex number. |
IMCOS | IMCOS | Returns the cosine of a complex number. |
IMDIV | IMDIV | Returns the quotient of two complex numbers. |
IMEXP | IMEXP | Returns the exponential function of a complex number. |
IMLN | IMLN | Returns the natural logarithm of a complex number. |
COMPLEXE.LOG10 | IMLOG10 | Calculates the base-10 logarithm of a complex number. |
IMLOG2 | IMLOG2 | Calculates the base-2 logarithm of a complex number. |
IMPOWER | IMPOWER | Returns a complex number raised to an integer power. |
IMPRODUCT | IMPRODUCT | Returns the product of several complex numbers. |
IMREAL | IMREAL | Returns the real coefficient of a complex number. |
IMSIN | IMSIN | Returns the sine of a complex number. |
IMSQRT | IMSQRT | Returns the square root of a complex number. |
IMSUB | IMSUB | Returns the difference between two complex numbers. |
IMSUM | IMSUM | Returns the sum of several complex numbers. |
OCTBIN | OCT2BIN | Converts an octal number to binary. |
octdec | OCT2DEC | Converts an octal number to decimal. |
OCTHEX | OCT2HEX | Converts an octal number to hexadecimal number. |
financial functions | Financial functions | |
ACCRINT | ACCRINT | Returns the accrued interest for a security which pays periodic interest. |
ACCRINTM | ACCRINTM | Returns the accrued interest for a security that pays interest at maturity. |
AMORDEGRC | AMORDEGRC | Returns the depreciation for each accounting period by using a depreciation coefficient. |
AMORLINC | AMORLINC | Returns the depreciation of an asset at the end of a given tax period. |
COUPDAYBS | COUPDAYBS | Returns the number of days between the beginning of the coupon period to the settlement date. |
NB.JOURS.COUPONS | COUPDAYS | Returns the number of days in the coupon period that contains the settlement date. |
COUPDAYSNC | COUPDAYSNC | Returns the number of days between the settlement date and the coupon date after the date of liquidation. |
COUPNCD. | COUPNCD | Returns the first coupon date after the settlement date. |
NB.COUPONS | COUPNUM | Returns the number of coupons payable between the settlement date and the maturity date. |
COUPPCD | COUPPCD | Returns the coupon date preceding the settlement date. |
CUMIPMT | CUMIPMT | Returns the cumulative interest paid on a loan between two periods. |
CUMPRINC | CUMPRINC | Returns the cumulative capital repayments of a loan made between two periods. |
DB | DB | Returns the depreciation of an asset for a specified period using the declining balance depreciation fixed rate. |
DDB | DDB | Returns the depreciation of an asset for a specified period using the declining balance method at double or as a coefficient to be specified. |
TAUX.ESCOMPTE | DISC | Calculates the discount rate of a transaction. |
DOLLARDE | DOLLARDE | Converts a euro price, expressed as a fraction of a euro price expressed as a decimal number. |
DOLLARFR | DOLLARFR | Converts a euro price, expressed as a decimal number, into a euro price expressed as a fraction. |
DURATION | DURATION | Returns the time, in years, of a security that pays periodic interest. |
EFFECT | EFFECT | Returns the annual effective interest rate. |
VC | FV | Returns the future value of an investment. |
FVSCHEDULE | FVSCHEDULE | Calculates the future value of an investment by applying a series of compound interest rates. |
INTRATE | INTRATE | Displays the interest rate for a fully invested security. |
IPMT | IPMT | Calculate the amount of interest on an investment for a given period. |
SORTING | IRR | Calculates the internal rate of return of an investment for a succession of treasuries. |
ISPMT | ISPMT | Calculate the amount of interest on an investment for a given period. |
DUREE.MODIFIEE | MDURATION | Returns the Macauley modified duration for a security with an assumed par value of 100_euros. |
TRIM | MIRR | Calculates the internal rate of return where positive and negative payments are financed at different rates. |
NOMINAL | NOMINAL | Calculates the annual nominal interest rate. |
NPM | RPS | Returns the number of necessary payments to repay a loan. |
VAN | NPV | Calculates the net present value of an investment based on a series of disbursements and a discount rate. |
ODDFPRICE | ODDFPRICE | Returns the price per $ 100 face value of a euro as the first coupon period is irregular. |
ODDFYIELD | ODDFYIELD | Returns the yield of a security with the first coupon period is irregular. |
ODDLPRICE | ODDLPRICE | Returns the price per $ 100 face value of a euro as the first coupon period is irregular. |
ODDLYIELD | ODDLYIELD | Returns the yield of a security with the last coupon period is irregular. |
VPM | PMT | Calculates the periodic payment of a given investment. |
PPMT | PPMT | Calculated for a given period, the share of repayment of the principal of an investment. |
PRIX.TITRE | PRICE | Returns the price of a security that pays periodic interest, for a nominal value of 100 euros. |
PRICEDISC | PRICEDISC | Returns the value of a collection commercial discount, for a nominal value of 100 euros. |
PRICEMAT | PRICEMAT | Returns the price of a security with a face value of 100 euros and that pays interest at maturity. |
GO | PV | Calculates the present value of an investment. |
RATE | MISSED | Calculates the interest rate per period for an annuity. |
VALEUR.NOMINALE | RECEIVED | Returns the nominal value at maturity of a negotiable instrument. |
SLN | SLN | Calculates the linear depreciation of an asset for a given period. |
SYD | SYD | Calculates the depreciation of an asset for a given period based on the sum-of-years' digits (declining balance decreasing rate applied to a constant value). |
TAUX.ESCOMPTE.R | TBILLEQ | Returns the rational discount rate of a Treasury bill. |
TBILLPRICE | TBILLPRICE | Returns the price of a Treasury bond with a nominal value of 100 euros. |
RENDEMENT.BON.TRESOR | TBILLYIELD | Calculates the yield of a treasury bill. |
VDB | VDB | Returns the depreciation of an asset for a specified or partial period using a declining balance depreciation fixed rate. |
XIRR | XIRR | Calculates the internal rate of return of a set of non-periodic payments. |
XNPV | XNPV | Returns the net present value of a set of non-periodic payments. |
YIELD | YIELD | Calculates the yield of a security that pays periodic interest. |
RENDEMENT.SIMPLE | YIELDDISC | Calculates the rate of return on a loan simple interest (for example, a Treasury bill). |
RENDEMENT.TITRE.ECHEANCE | YIELDMAT | Returns the annual yield of a security that pays interest at maturity. |
Information Functions | information functions | |
CELL | CELL | Returns information about the formatting, location and content of a cell. |
ERROR.TYPE | ERROR.TYPE | Returns a number corresponding to an error type. |
INFORMATION | INFO | Returns information about the current operating environment. |
IS EMPTY | ISBLANK | Returns TRUE if the value is empty. |
ISERR | ISERR | Returns TRUE if the value refers to any error value except # N / A. |
ISERROR | ISERROR | Returns TRUE if the value refers to an error value. |
ISEVEN | ISEVEN | Returns TRUE if the number is even. |
ISLOGICAL | ISLOGICAL | Returns TRUE if the value refers to a logical value. |
ISNA | ISNA | Returns TRUE if the value refers to the error value # N / A. |
ISNONTEXT | ISNONTEXT | Returns TRUE if the value is not in the form of text. |
ISNUMBER | ISNUMBER | Returns TRUE if value is a number. |
ISODD | ISODD | Returns TRUE if the number is odd. |
ISREF | ISREF | Returns TRUE if value is a reference. |
ISTEXT | ISTEXT | Returns TRUE if the value is in the form of text. |
N | N | Returns a value converted to a number. |
N / A | N / A | Returns the error value # N / A. |
TYPE | TYPE | Returns a number indicating the data type of a value. |
logical functions | Logical functions | |
AND | AND | Returns TRUE if all its arguments are TRUE. |
FALSE | FALSE | Returns the logical value FALSE. |
IF | IF | Specifies a logical test to perform. |
IFERROR | IFERROR | Returns a value you specify if a formula generates an error; otherwise it returns the result of the formula. |
NO | NOT | Reverses the logic of this argument. |
OR | GOLD | Returns TRUE if any argument is TRUE. |
TRUE | TRUE | Returns logical TRUE. |
Research and reference functions | Lookup and reference functions | |
ADDRESS | ADDRESS | Returns a reference as text to a single cell of a spreadsheet. |
AREAS | AREAS | Returns the number of areas in a reference. |
TO CHOOSE | CHOOSE | Chooses a value from a list. |
COLUMN | COLUMN | Returns a reference column number. |
COLUMNS | COLUMNS | Returns the number of columns in a reference. |
HLOOKUP | HLOOKUP | Searches in the first row of a matrix and returns the value of the indicated cell. |
HYPERLINK | HYPERLINK | Creates a shortcut or reference that opens a document stored on a network server, an intranet or the Internet. |
INDEX | INDEX | Uses an index to choose a value from a reference or array. |
INDIRECT | INDIRECT | Returns a reference indicated by a text value. |
RESEARCH | LOOKUP | Search for values in a vector or matrix. |
MATCH | MATCH | Search for values in a reference or array. |
SHIFT | OFFSET | Returns a reference offset in relation to a given reference. |
LINE | ROW | Returns the reference of a line number. |
LINES | ROWS | Returns the number of rows in a reference. |
RTD | RTD | Retrieves real-time data from a program that supports COM automation (Automation: working with objects on an application from another application or another development tool Formerly called OLE Automation. Automation is an industry standard and a feature of the COM object model (Component object model).). |
TRANSPOSE | TRANSPOSE | Returns the transpose of a matrix. |
VLOOKUP | VLOOKUP | Searches in the first column of an array and moves across the row to return the value of a cell. |
math and trigonometric functions | Math and trigonometry functions | |
ABS | ABS | Returns the absolute value of a number. |
ACOS | ACOS | Returns the arc cosine of a number. |
ACOSH | ACOSH | Returns the inverse hyperbolic cosine of a number. |
ASIN | ASIN | Returns the arcsine of a number. |
ASINH | ASINH | Returns the inverse hyperbolic sine of a number. |
ATAN | ATAN | Returns the arc tangent of a number. |
ATAN2 | ATAN2 | Returns the arc tangent of x and y coordinates. |
ATANH | ATANH | Returns the inverse hyperbolic tangent of a number. |
CEILING | CEILING | Rounds a number to the nearest integer or to the nearest multiple of the precision argument away from zero. |
COMBINED | COMBINED | Returns the number of combinations that can be formed with a given number of objects. |
COS | COS | Returns the cosine of a number. |
COSH | COSH | Returns the hyperbolic cosine of a number. |
DEGREES | DEGREES | Converts radians to degrees. |
PEER | EVEN | Rounds a number to the nearest even integer away from zero. |
EXP | EXP | Returns e raised to the power of a given number. |
FACT | FACT | Returns the factorial of a number. |
FACTDOUBLE | FACTDOUBLE | Returns the double factorial of a number. |
FLOOR | FLOOR | Rounds a number down, toward 0 (zero). |
GCD | GCD | Returns the greatest common divisor. |
ENT | INT | Rounds a number to the nearest integer. |
LCM | LCM | Returns the least common multiple. |
LN | LN | Returns the natural logarithm of a number. |
LOG | LOG | Returns the logarithm of a number in the specified base. |
LOG10 | LOG10 | Calculates the base-10 logarithm of a number. |
MDETERM | MDETERM | Returns the determinant of a matrix. |
MINVERSE | MINVERSE | Returns the inverse matrix of a matrix. |
MMULT | MMULT | Returns the product of two matrices. |
MOD | MOD | Returns the remainder of a division. |
MROUND | MROUND | Gives the round a number to the specified multiple. |
MULTINOMIAL | MULTINOMIAL | Calculates the multinomial of a set of numbers. |
ODD | ODD | Returns the number rounded to the value of the nearest odd integer away from zero. |
PI | PI | Returns the value of pi. |
POWER | POWER | Returns the value of the number raised to a power. |
PRODUCT | PRODUCT | Multiplies its arguments. |
QUOTIENT | QUOTIENT | Returns the integer part of the result of a division. |
RADIANS | RADIANS | Converts degrees to radians. |
ALEA | RAND | Returns a random number between 0 and 1. |
RANDBETWEEN | RANDBETWEEN | Returns a random number between the numbers you specify. |
ROMAN | NOVEL | Converts Arabic numerals in Roman numbers, as text. |
ROUND | ROUND | Rounds a number to the specified number of digits. |
ROUNDDOWN | ROUNDDOWN | Rounds a number down, toward 0 (zero). |
ROUNDUP | ROUNDUP | Rounds a number to the next higher integer, away from zero. |
SERIESSUM | SERIESSUM | Returns the sum of a geometric series based on the following formula: |
SIGN | SIGN | Returns the sign of a number. |
SIN | SIN | Returns the sine of a given angle. |
SINH | SINH | Returns the hyperbolic sine of a number. |
ROOT | SQRT | Returns the square root of a number. |
SQRTPI | SQRTPI | Returns the square root of (number * pi). |
SOUS.TOTAL | SUBTOTAL | Returns a subtotal in a list or database. |
SUM | SUM | Calculates the sum of its arguments. |
SOMME.SI | SUMIF | Adds the cells specified if they meet a given criteria. |
SOMME.SI.ENS | SUMIFS | Adds the cells in a range that meet multiple criteria. |
SUMPRODUCT | SUMPRODUCT | Multiplies the corresponding values specified matrices and calculates the sum of these products. |
SUMSQ | SUMSQ | Returns the sum of the squares of the arguments. |
SUMX2MY2 | SUMX2MY2 | Returns the sum of the difference of squares of corresponding values of two matrices. |
SUMX2PY2 | SUMX2PY2 | Returns the sum of the sum of squares of corresponding values of two matrices. |
SUMXMY2 | SUMXMY2 | Returns the sum of the squared differences between the corresponding values of two matrices. |
TAN | TAN | Returns the tangent of a number. |
TANH | TANH | Returns the hyperbolic tangent of a number. |
TRUNCATED | TRUNC | Returns the integer part of a number. |
statistical functions | Statistical functions | |
AVEDEV | AVEDEV | Returns the average of the absolute deviations observed in the average of the data points. |
AVERAGE | AVERAGE | Returns the average of its arguments. |
AVERAGEA | AVERAGEA | Returns the average of its arguments, numbers, text and logical values. |
MOYENNE.SI | AVERAGEIF | Returns the average (arithmetic mean) of all cells in a range that meet the given criteria. |
MOYENNE.SI | AVERAGEIFS | Returns the average (arithmetic mean) of all cells that meet multiple criteria. |
BETADIST | BETADIST | Returns the cumulative distribution function. |
BETAINV | BETAINV | Returns the inverse of the cumulative distribution function for a specified beta distribution. |
BINOMDIST | BINOMDIST | Returns the probability of a discrete random variable Binomial. |
CHIDIST | CHIDIST | Returns the one-tailed probability of the chi-square distribution. |
CHIINV | CHIINV | Returns the inverse of the one-tailed probability of the chi-square distribution. |
CHITEST | ChiTest | Returns the test for independence. |
CONFIDENCE | CONFIDENCE | Returns the confidence interval for a population mean. |
CORREL | CORREL | Returns the correlation coefficient between two data sets. |
NB | COUNT | Determines the numbers included in the list of arguments. |
COUNTA | COUNTA | Determines the number of values in the argument list. |
COUNTBLANK | COUNTBLANK | Count the number of empty cells in a range. |
NB.SI | COUNTIF | Count the number of cells that meet a given criteria in a range. |
COUNTIFS | COUNTIFS | Count the number of cells within a range that meet multiple criteria. |
COVARIANCE | COVAR | Returns covariance, the average deviations of products for each series of observations. |
CRITBINOM | CRITBINOM | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. |
DEVSQ | DEVSQ | Returns the sum of squared deviations. |
EXPONDIST | EXPONDIST | Returns the exponential distribution. |
FDIST | FDIST | Returns the F probability distribution |
FINV | FINV | Returns the inverse of the probability distribution F |
FISHER | FISHER | Returns the Fisher transformation. |
FISHERINV | FISHERINV | Returns the inverse of the Fisher transformation. |
FORECAST | FORECAST | Calculates a value from a linear trend. |
FREQUENCY | FREQUENCY | Calculates the frequency of occurrence of values in a range of values, and returns the numbers in a vertical array. |
FTEST | fTest | Returns the result of an F test |
GAMMADIST | GAMMADIST | Returns the probability of a random variable following a gamma distribution. |
GAMMAINV | GAMMAINV | Returns for a given probability, the value of a random variable following a gamma distribution. |
GAMMALN | GAMMALN | Returns the natural logarithm of the Gamma function, G (x) |
GEOMEAN | GEOMEAN | Returns the geometric mean. |
GROWTH | GROWTH | Calculates values relative to an exponential trend. |
HARMEAN | HARMEAN | Returns the harmonic mean. |
HYPGEOMDIST | HYPGEOMDIST | Returns the probability of a discrete random variable hypergeometric. |
INTERCEPT | INTERCEPT | Returns the intercept of a linear regression line. |
KURT | KURT | Returns the kurtosis of a data series. |
GREAT VALUE | WIDE | Returns the k-th largest value in a data set. |
LINEST | LINEST | Returns the parameters of a linear trend. |
LOGEST | LOGEST | Returns the parameters of an exponential trend. |
LOGINV | LOGINV | Returns the inverse of the probability that a random variable the lognormal. |
LOGNORMDIST | LOGNORMDIST | Returns the probability of a continuous random variable following a lognormal. |
MAX | MAX | Returns the maximum value in a list of arguments. |
MAXA | MAXA | Returns the maximum value in a list of arguments, numbers, text and logical values. |
MEDIAN | MEDIAN | Returns the median of the given numbers. |
MIN | MIN | Returns the minimum value in a list of arguments. |
MINA | MINA | Returns the smallest value in a list of arguments, numbers, text and logical values. |
FASHION | FASHION | Returns the most common value in a data series. |
NEGBINOMDIST | NEGBINOMDIST | Returns the probability of a discrete random variable following a negative binomial distribution. |
NORMAL LAW | NORMDIST | Returns the probability of a continuous random variable following a normal distribution. |
NORMINV | NORMINV | Returns for a given probability, the value of a random variable following a standard normal distribution. |
NORMSDIST | NORMSDIST | Returns the probability of a continuous random variable following a standard normal distribution. |
NORMSINV | NORMSINV | Returns the inverse of the standard normal cumulative distribution. |
PEARSON | PEARSON | Returns the sample correlation coefficient of Pearson. |
PERCENTILE | PERCENTILE | Returns the k-th percentile of values in a range. |
PERCENTRANK | PERCENTRANK | Returns the percentage rank of a value of a data series. |
PERMUTATION | PERMUT | Returns the number of permutations for a given number of objects. |
POISSON | FISH | Returns the probability of a random variable following a Poisson distribution. |
PROBABILITY | PROB | Returns the probability that the values are a range between two limits. |
QUARTILE | QUARTILE | Returns the quartile of a data set. |
RANK | RANK | Returns the rank of a number in a list. |
RSQ | RSQ | Returns the value of the coefficient of determination R ^ 2 of a linear regression. |
SKEW | SKEW | Returns the skewness of a distribution. |
SLOPE | SLOPE | Returns the slope of a linear regression line. |
SMALL | SMALL | Returns the k-th smallest value in a data set. |
CENTREE.REDUITE | STANDARDIZE | Returns a z-value. |
STDEV | STDEV | Evaluate the standard deviation of a population based on a sample of that population. |
STDEVA | STDEVA | Evaluate the standard deviation of a population based on a sample of the population, numbers, text and logical values. |
STDEVP | STDEVP | Calculates the standard deviation of a population from the entire population. |
STDEVPA | STDEVPA | Calculates the standard deviation of a population from the total population, numbers, text and logical values. |
STEYX | STEYX | Returns the standard error of the predicted y value for each x in the regression. |
TDIST | TDIST | Returns the probability of a random variable T Student distribution. |
TINV | TINV | Returns for a given probability, the value of a random variable T Student distribution. |
TREND | TREND | Returns values from a linear trend. |
TRIMMEAN | TRIMMEAN | Returns the average of the inside of a data series. |
TTEST | TTEST | Returns the probability associated with a Student T test. |
VAR | VAR | Calculates variance based on a sample. |
VARA | VARA | Estimates the variance of a population based on a sample of the population, numbers, text and logical values included. |
VARP | VARP | Calculates variance based on the entire population. |
VARPA | VARPA | Calculates the variance of a population based on the entire population, numbers, text and logical values. |
WEIBULL | WEIBULL | Returns the probability of a random variable following a Weibull distribution. |
ZTEST | ZTEST | Returns the one-tailed probability value of a z-test. |
Text Functions | text functions | |
ASC | ASC | Change English characters or katakana to full-width (double-byte) within a string to half-width characters (byte). |
BAHTTEXT | BAHTTEXT | Converts a number to text using currency format ß (baht). |
BECAUSE | TANK | Returns the character specified by the code number. |
CLEAN | CLEAN | Removes all text control characters. |
CODE | CODE | Returns the code of the first character of the text. |
CONCATENATE | CONCATENATE | Joins several text elements so as not to form one. |
EURO | DOLLAR | Converts a number to text using currency format € (Euro). |
EXACT | EXACT | Checks if two text values are identical. |
FOUND, TROUVERB | FIND, FINDB | Is a textual value in another case sensitive. |
FIXED | FIXED | Converts a number to text with a specified number of decimal places. |
JIS | JIS | Change English characters or katakana half-width (single-byte) into a character string to full-width characters (double byte). |
LEFT GAUCHEB | LEFT, LEFTB | Returns characters on the far left of a string. |
LEN, LENB | LEN, LENB | Returns the number of characters in a text string. |
TINY | LOWER | Converts text to lowercase. |
MID, STXTB | MID, MIDB | Returns a specified number of characters from a text string from the position you specify. |
PHONETIC | PHONETIC | Extract phonetic characters (furigana) of a text string. |
PROPER NOUN | PROPER | Capitalizes the first letter of each word in a text string. |
REPLACE REPLACEB | REPLACE, REPLACEB | Replaces characters within text. |
REPT | REPT | Repeats text a number of times. |
RIGHT DROITEB | RIGHT, RIGHTB | Returns characters to the extreme right of a string. |
SEARCH, CHERCHERB | SEARCH, SEARCHB | Find a text in another text (not case sensitive). |
SUBSTITUTED | SUBSTITUTE | Replaces the old text in a string with a new one. |
T | T | Converts its arguments to text. |
TEXT | TEXT | Converts a number to text. |
TRIM | TRIM | Removes the text field. |
CAPITAL | UPPER | Converts text to uppercase. |
VALUE | VALUE | Converts a text argument to a number |