Excel 2007 fonctions French-English
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 from one currency in 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 registry identification number of the dynamic link library that was specified or code resource that has been put into the register above. |
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 KPI and displays the name and property in the cell. A KPI is a quantifiable measure, such as profit margin or gross monthly quarterly turnover, used to evaluate the performance of a company. |
MEMBRECUBE | CUBEMEMBER | Returns a member or tuple in a cube hierarchy. Use this function 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 function 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 member placed at a certain rank in a set. Use to return one or more elements of a set, such as best sellers or top 10 students. |
JEUCUBE | CUBESET | Defines a set of calculated members or tuples by sending a term defined in 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 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 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 of the database that meet the criteria. |
DVAR | SSDs | Calculates the variance for a sample of database entries of selected data. |
DVARP | DVARP | Calculates the variance for the entire population of selected database entries. |
Date and Time Functions | Date and time functions | |
DATE | DATE | Returns the serial number of a specific date. |
DATEVALUE | DATEVALUE | Converts a date represented in text form serial number. |
DAY | DAY | Converts a serial number of 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 argument start_date) corrected or down the specified number of months. |
EOMONTH | EOMONTH | Returns the sequential number of the last day of the month before or after start_date the specified number of months. |
TIME | 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. |
RIGHT 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 days worked. |
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. |
SELF CONSCIOUS | 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 to octal number. |
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 | Testing 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. |
COMPLEXE.DIV | 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. |
COMPLEXE.DIFFERENCE | 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 number. |
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 that 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 using a damping coefficient. |
AMORLINC | AMORLINC | Returns the depreciation of an asset at the end of a given tax period. |
COUPDAYBS | COUPDAYBS | Returns the number of days from the beginning of the coupon period to the date of liquidation. |
COUPDAYS | 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 date of the next coupon date of liquidation. |
COUPNCD. | COUPNCD | Returns the first coupon date after the settlement date. |
COUPNUM | 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 method at fixed rates. |
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 dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number. |
DOLLARFR | DOLLARFR | Converts a dollar price, expressed as a decimal number, into a dollar 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 of a fully invested security. |
IPMT | IPMT | Calculates the amount of interest on an investment for a given period. |
TRI | IRR | Calculates the internal rate of return of an investment in a succession of treasuries. |
ISPMT | ISPMT | Calculates 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 that 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 | PLMP | 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 whose nominal value is EUR 100 and that pays interest at maturity. |
VA | PV | Calculates the present value of an investment. |
RATE | RATE | 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 specified period. |
SYD | SYD | Calculates the depreciation of an asset for a given period on the basis of the sum-of-years' digits (declining balance rate applied descending at 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 face 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 method at fixed rates. |
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 interest periodically. |
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 on the layout, the location and contents of a cell. |
ERROR.TYPE | ERROR.TYPE | Returns a number corresponding to an error type. |
INFORMATION | INFO | Returns information about the current operating environment. |
ISBLANK | ISBLANK | Returns TRUE if value is empty. |
ISERR | ISERR | Returns TRUE if value refers to any error value except # N / A. |
ISERROR | ISERROR | Returns TRUE if value refers to an error value. |
ISEVEN | ISEVEN | Returns TRUE if the number is even. |
ISLOGICAL | ISLOGICAL | Returns TRUE if value refers to a logical value. |
ISNA | ISNA | Returns TRUE if value refers to the error value # N / A. |
ISNONTEXT | ISNONTEXT | Returns TRUE if 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 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. |
SI | IF | Specifies a logical test to perform. |
IFERROR | IFERROR | Returns a value that you specify if a formula generates an error; otherwise it returns the result of the formula. |
I DONT NO | NOT | Reverses the logic of this argument. |
OR | OR | Returns TRUE if any argument is TRUE. |
TRUE | TRUE | Returns the logical value TRUE. |
Research and reference functions | Lookup and reference functions | |
ADDRESS | ADDRESS | Returns a reference as text to a single cell of a spreadsheet. |
ZONES | AREAS | Returns the number of areas in a reference. |
CHOOSE | CHOOSE | Chooses a value from a list. |
COLUMN | COLUMN | Returns a reference to the column number. |
COLUMNS | COLUMNS | Returns the number of columns in a reference. |
HLOOKUP | HLOOKUP | Performs a search 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 a matrix. |
INDIRECT | INDIRECT | Returns a reference indicated by a text value. |
SOUGHT AFTER | LOOKUP | Mark values in a vector or a matrix. |
MATCH | MATCH | Search for values in a reference or array. |
OFFSET | OFFSET | Returns a reference offset relative to a given reference. |
ONLINE | ROW | Returns a reference to the 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: Using objects in 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 | Performs a search in the first column of a matrix and moves on the line to return the value of a cell. |
Mathematical 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 arctangent of a number. |
ATAN2 | ATAN2 | Returns the arctangent of x and y coordinates. |
ATANH | ATANH | Returns the inverse hyperbolic tangent of a number. |
CEILING | CEILING | Rounds a number to the nearest whole number or the nearest multiple of 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. |
PAIR | 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 zero (0). |
GCD | GCD | Returns the greatest common divisor. |
ENT | INT | Rounds a number down 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 | Give rounding 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. |
ROMAIN | ROMAN | Converts Arabic numerals Roman numerals as text. |
ROUND | ROUND | Rounds a number to the specified number of digits. |
ROUNDDOWN | ROUNDDOWN | Rounds a number down, toward zero (0). |
ROUNDUP | ROUNDUP | Rounds a number to the next whole, away from zero. |
SERIESSUM | SERIESSUM | Returns the sum of a geometric series based on the following formula: |
SIGNS | SIGN | Returns the sign of a number. |
SIN | SIN | Returns the sine of the given angle. |
SINH | SINH | Returns the hyperbolic sine of a number. |
RACINE | SQRT | Returns the square root of a number. |
SQRTPI | SQRTPI | Returns the square root of (number * pi). |
SUBTOTAL | 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 the squares of corresponding values of two matrices. |
SUMX2PY2 | SUMX2PY2 | Returns the sum of the sum of the squares of corresponding values of two matrices. |
SUMXMY2 | SUMXMY2 | Returns the sum of the squared differences between the corresponding values of the two matrices. |
TAN | TAN | Returns the tangent of a number. |
TANH | TANH | Returns the hyperbolic tangent of a number. |
TRUNC | 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 the binomial distribution. |
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-squared 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 | Counts the number of cells that meet a given criteria in a range. |
COUNTIFS | COUNTIFS | Counts the number of cells within a range that meet multiple criteria. |
COVARIANCE | COVAR | Returns covariance, mean deviation 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 probability distribution F. |
FINV | FINV | Returns the inverse of the probability distribution F. |
FISHER | FISHER | Returns the Fisher transformation. |
FISHERINV | FISHERINV | Returns the inverse of the transformation of Fisher. |
PREDICTION | FORECAST | Calculates a value from a linear trend. |
FREQUENCY | FREQUENCY | Calculates the frequency of occurrence of values in a range of values, and then returns the numbers as 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 distribution. |
INTERCEPT | INTERCEPT | Returns the y-intercept of a linear regression line. |
KURT | KURT | Returns the kurtosis of a series of data. |
LARGE | LARGE | 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 distribution. |
LOGNORMDIST | LOGNORMDIST | Returns the probability of a continuous random variable following a lognormal distribution. |
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. |
MODE | MODE | Returns the most common value in a data set. |
NEGBINOMDIST | NEGBINOMDIST | Returns the probability of a discrete random variable following a negative binomial distribution. |
NORMDIST | 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. |
CENTILE | PERCENTILE | Returns the k-th percentile of values in a range. |
PERCENTRANK | PERCENTRANK | Returns the percentage rank of a value of a data series. |
SWITCHING | 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. |
CHANCE | 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 | Evaluates the standard deviation of a population based on a sample of that population. |
STDEVA | STDEVA | Evaluates 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 law. |
TINV | TINV | Returns for a given probability, the value of a random variable T Student law. |
TREND | TREND | Returns values compared to a linear trend. |
TRIMMEAN | TRIMMEAN | Returns the average of the interior of a series of data. |
TTEST | TTEST | Returns the probability associated with a Student T test. |
VAR | VAR | Calculates the variance on the basis of 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 the 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 full-width katakana (double-byte) within a string to half-width characters (byte). |
BAHTTEXT | BAHTTEXT | Converts a number to text using currency format ß (baht). |
BECAUSE | CHAR | Returns the character specified by the numeric code. |
CLEAN | CLEAN | Deletes all text control characters. |
CODE | CODE | Returns the code of the first character of the text. |
CONCATENATE | CONCATENATE | Assemble multiple text elements so as not 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 text value within another, case sensitive. |
FIXED | FIXED | Converts a number to text with a specified number of decimal places. |
JIS | JIS | Change English characters or half-width katakana (byte) within a string at full width characters (DBCS). |
LEFT, GAUCHEB | LEFT, LEFTB | Returns the characters on the far left of a string. |
LEN, LENB | LEN, LENB | Returns the number of characters in a text string. |
SMALL | LOWER | Converts text to lowercase. |
MID, STXTB | MID, MIDB | Returns a specified number of characters from a text string from the location you specify. |
PHONETICS | PHONETIC | Extracts the phonetic characters (furigana) of a text string. |
PROPER | PROPER | Capitalizes the first letter of each word in a text string. |
REPLACE REMPLACERB | 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 (case-insensitive). |
SUBSTITUTES | SUBSTITUTE | Replaces the old text of a string with a new one. |
T | T | Converts its arguments to text. |
TEXT | TEXT | Converts a number to text. |
TRIM | TRIM | Deletes text areas. |
CAPITAL | UPPER | Converts text to uppercase. |
VALUE | VALUE | Converts a text argument to a number |