﻿ Translation of Excel 2010 functions

# List of Excel functions with translations to 15 European languages

Please click on the Excel 2010 functions in this table to see translations into 15 European languages.

EnglishDescription
ABSReturns the absolute value of a number
ACCRINTReturns the accrued interest for a security that pays periodic interest
ACCRINTMReturns the accrued interest for a security that pays interest at maturity
ACOSReturns the arccosine of a number
ACOSHReturns the inverse hyperbolic cosine of a number
ADDRESSReturns a reference as text to a single cell in a worksheet
AMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficient
AMORLINCReturns the depreciation for each accounting period
ANDReturns TRUE if all of its arguments are TRUE
AREASReturns the number of areas in a reference
ASCChanges full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
ASINReturns the arcsine of a number
ASINHReturns the inverse hyperbolic sine of a number
ATANReturns the arctangent of a number
ATAN2Returns the arctangent from x- and y-coordinates
ATANHReturns the inverse hyperbolic tangent of a number
AVEDEVReturns the average of the absolute deviations of data points from their mean
AVERAGEReturns the average of its arguments
AVERAGEAReturns the average of its arguments, including numbers, text, and logical values
BAHTTEXTConverts a number to text, using the ß (baht) currency format
BESSELIReturns the modified Bessel function In(x)
BESSELJReturns the Bessel function Jn(x)
BESSELKReturns the modified Bessel function Kn(x)
BESSELYReturns the Bessel function Yn(x)
BETA.DISTReturns the beta cumulative distribution function
BETA.INVReturns the inverse of the cumulative distribution function for a specified beta distribution
BETADISTReturns the beta cumulative distribution function
BETAINVReturns the inverse of the cumulative distribution function for a specified beta distribution
BIN2DECConverts a binary number to decimal
BIN2HEXConverts a binary number to hexadecimal
BIN2OCTConverts a binary number to octal
BINOM.DISTReturns the individual term binomial distribution probability
BINOM.INVReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
BINOMDISTReturns the individual term binomial distribution probability
CALLCalls a procedure in a dynamic link library or code resource
CEILINGRounds a number to the nearest integer or to the nearest multiple of significance
CELLReturns information about the formatting, location, or contents of a cell NoteThis function is not available in Excel Web App.
CHARReturns the character specified by the code number
CHIDISTReturns the one-tailed probability of the chi-squared distribution
CHIINVReturns the inverse of the one-tailed probability of the chi-squared distribution
CHISQ.DIST.RTReturns the one-tailed probability of the chi-squared distribution
CHISQ.INV.RTReturns the inverse of the one-tailed probability of the chi-squared distribution
CHISQ.TESTReturns the test for independence
CHITESTReturns the test for independence
CHOOSEChooses a value from a list of values
CLEANRemoves all nonprintable characters from text
CODEReturns a numeric code for the first character in a text string
COLUMNReturns the column number of a reference
COLUMNSReturns the number of columns in a reference
COMBINReturns the number of combinations for a given number of objects
COMPLEXConverts real and imaginary coefficients into a complex number
CONCATENATEJoins several text items into one text item
CONFIDENCEReturns the confidence interval for a population mean
CONFIDENCE.NORMReturns the confidence interval for a population mean
CONVERTConverts a number from one measurement system to another
CORRELReturns the correlation coefficient between two data sets
COSReturns the cosine of a number
COSHReturns the hyperbolic cosine of a number
COUNTCounts how many numbers are in the list of arguments
COUNTACounts how many values are in the list of arguments
COUNTBLANKCounts the number of blank cells within a range
COUNTIFCounts the number of cells within a range that meet the given criteria
COUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement date
COUPDAYSReturns the number of days in the coupon period that contains the settlement date
COUPDAYSNCReturns the number of days from the settlement date to the next coupon date
COUPNCDReturns the next coupon date after the settlement date
COUPNUMReturns the number of coupons payable between the settlement date and maturity date
COUPPCDReturns the previous coupon date before the settlement date
COVARReturns covariance, the average of the products of paired deviations
COVARIANCE.PReturns covariance, the average of the products of paired deviations
CRITBINOMReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
CUMIPMTReturns the cumulative interest paid between two periods
CUMPRINCReturns the cumulative principal paid on a loan between two periods
DATEReturns the serial number of a particular date
DATEVALUEConverts a date in the form of text to a serial number
DAVERAGEReturns the average of selected database entries
DAYConverts a serial number to a day of the month
DAYS360Calculates the number of days between two dates based on a 360-day year
DBReturns the depreciation of an asset for a specified period by using the fixed-declining balance method
DCOUNTCounts the cells that contain numbers in a database
DCOUNTACounts nonblank cells in a database
DDBReturns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
DEC2BINConverts a decimal number to binary
DEC2HEXConverts a decimal number to hexadecimal
DEC2OCTConverts a decimal number to octal
DELTATests whether two values are equal
DEVSQReturns the sum of squares of deviations
DGETExtracts from a database a single record that matches the specified criteria
DISCReturns the discount rate for a security
DMAXReturns the maximum value from selected database entries
DMINReturns the minimum value from selected database entries
DOLLARConverts a number to text, using the \$ (dollar) currency format
DOLLARDEConverts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
DOLLARFRConverts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
DPRODUCTMultiplies the values in a particular field of records that match the criteria in a database
DSTDEVEstimates the standard deviation based on a sample of selected database entries
DSTDEVPCalculates the standard deviation based on the entire population of selected database entries
DSUMAdds the numbers in the field column of records in the database that match the criteria
DURATIONReturns the annual duration of a security with periodic interest payments
DVAREstimates variance based on a sample from selected database entries
DVARPCalculates variance based on the entire population of selected database entries
EDATEReturns the serial number of the date that is the indicated number of months before or after the start date
EFFECTReturns the effective annual interest rate
EOMONTHReturns the serial number of the last day of the month before or after a specified number of months
ERFReturns the error function
ERF.PRECISEReturns the error function
ERFCReturns the complementary error function
ERFC.PRECISEReturns the complementary ERF function integrated between x and infinity
ERROR.TYPEReturns a number corresponding to an error type
EUROCONVERTConverts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation).
EVENRounds a number up to the nearest even integer
EXACTChecks to see if two text values are identical
EXPReturns e raised to the power of a given number
EXPON.DISTReturns the exponential distribution
EXPONDISTReturns the exponential distribution
F.DIST.RTReturns the F probability distribution
F.INV.RTReturns the inverse of the F probability distribution
F.TESTReturns the result of an F-test
FACTReturns the factorial of a number
FACTDOUBLEReturns the double factorial of a number
FALSEReturns the logical value FALSE
FDISTReturns the F probability distribution
FIND, FINDBFinds one text value within another (case-sensitive)
FINVReturns the inverse of the F probability distribution
FISHERReturns the Fisher transformation
FISHERINVReturns the inverse of the Fisher transformation
FIXEDFormats a number as text with a fixed number of decimals
FLOORRounds a number down, toward zero
FORECASTReturns a value along a linear trend
FREQUENCYReturns a frequency distribution as a vertical array
FTEST
FVReturns the future value of an investment
FVSCHEDULEReturns the future value of an initial principal after applying a series of compound interest rates
GAMMA.DISTReturns the gamma distribution
GAMMA.INVReturns the inverse of the gamma cumulative distribution
GAMMAINVReturns the inverse of the gamma cumulative distribution
GAMMALNReturns the natural logarithm of the gamma function, Γ(x)
GAMMALN.PRECISEReturns the natural logarithm of the gamma function, Γ(x)
GCDReturns the greatest common divisor
GEOMEANReturns the geometric mean
GESTEPTests whether a number is greater than a threshold value
GETPIVOTDATAReturns data stored in a PivotTable report
GROWTHReturns values along an exponential trend
HARMEANReturns the harmonic mean
HEX2BINConverts a hexadecimal number to binary
HEX2DECConverts a hexadecimal number to decimal
HEX2OCTConverts a hexadecimal number to octal
HLOOKUPLooks in the top row of an array and returns the value of the indicated cell
HOURConverts a serial number to an hour
HYPERLINKCreates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
HYPGEOM.DISTReturns the hypergeometric distribution
HYPGEOMDISTReturns the hypergeometric distribution
IFSpecifies a logical test to perform
IMABSReturns the absolute value (modulus) of a complex number
IMAGINARYReturns the imaginary coefficient of a complex number
IMARGUMENTReturns the argument theta, an angle expressed in radians
IMCONJUGATEReturns the complex conjugate of a complex number
IMCOSReturns the cosine of a complex number
IMDIVReturns the quotient of two complex numbers
IMEXPReturns the exponential of a complex number
IMLNReturns the natural logarithm of a complex number
IMLOG10Returns the base-10 logarithm of a complex number
IMLOG2Returns the base-2 logarithm of a complex number
IMPOWERReturns a complex number raised to an integer power
IMPRODUCTReturns the product of complex numbers
IMREALReturns the real coefficient of a complex number
IMSINReturns the sine of a complex number
IMSQRTReturns the square root of a complex number
IMSUBReturns the difference between two complex numbers
IMSUMReturns the sum of complex numbers
INDEXUses an index to choose a value from a reference or array
INDIRECTReturns a reference indicated by a text value
INFOReturns information about the current operating environment NoteThis function is not available in Excel Web App.
INTRounds a number down to the nearest integer
INTERCEPTReturns the intercept of the linear regression line
INTRATEReturns the interest rate for a fully invested security
IPMTReturns the interest payment for an investment for a given period
IRRReturns the internal rate of return for a series of cash flows
ISODDReturns TRUE if the number is odd
ISPMTCalculates the interest paid during a specific period of an investment
ISTEXTReturns TRUE if the value is text
JISChanges half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters
KURTReturns the kurtosis of a data set
LARGEReturns the k-th largest value in a data set
LCMReturns the least common multiple
LEFT, LEFTBReturns the leftmost characters from a text value
LEN, LENBReturns the number of characters in a text string
LINESTReturns the parameters of a linear trend
LNReturns the natural logarithm of a number
LOGReturns the logarithm of a number to a specified base
LOG10Returns the base-10 logarithm of a number
LOGESTReturns the parameters of an exponential trend
LOGINVReturns the inverse of the lognormal cumulative distribution
LOGNORM.DISTReturns the cumulative lognormal distribution
LOGNORM.INVReturns the inverse of the lognormal cumulative distribution
LOGNORMDISTReturns the cumulative lognormal distribution
LOOKUPLooks up values in a vector or array
LOWERConverts text to lowercase
MATCHLooks up values in a reference or array
MAXReturns the maximum value in a list of arguments
MAXAReturns the maximum value in a list of arguments, including numbers, text, and logical values
MDETERMReturns the matrix determinant of an array
MDURATIONReturns the Macauley modified duration for a security with an assumed par value of \$100
MEDIANReturns the median of the given numbers
MID, MIDBReturns a specific number of characters from a text string starting at the position you specify
MINReturns the minimum value in a list of arguments
MINAReturns the smallest value in a list of arguments, including numbers, text, and logical values
MINUTEConverts a serial number to a minute
MINVERSEReturns the matrix inverse of an array
MIRRReturns the internal rate of return where positive and negative cash flows are financed at different rates
MMULTReturns the matrix product of two arrays
MODReturns the remainder from division
MODEReturns the most common value in a data set
MODE.SNGLReturns the most common value in a data set
MONTHConverts a serial number to a month
MROUNDReturns a number rounded to the desired multiple
MULTINOMIALReturns the multinomial of a set of numbers
NReturns a value converted to a number
NAReturns the error value #N/A
NEGBINOM.DISTReturns the negative binomial distribution
NEGBINOMDISTReturns the negative binomial distribution
NETWORKDAYSReturns the number of whole workdays between two dates
NOMINALReturns the annual nominal interest rate
NORM.DISTReturns the normal cumulative distribution
NORM.INVReturns the inverse of the normal cumulative distribution
NORM.S.DISTReturns the standard normal cumulative distribution
NORM.S.INVeturns the inverse of the standard normal cumulative distribution
NORMDISTReturns the normal cumulative distribution
NORMINVReturns the inverse of the normal cumulative distribution
NORMSDISTReturns the standard normal cumulative distribution
NORMSINVReturns the inverse of the standard normal cumulative distribution
NOTReverses the logic of its argument
NOWReturns the serial number of the current date and time
NPERReturns the number of periods for an investment
NPVReturns the net present value of an investment based on a series of periodic cash flows and a discount rate
OCT2BINConverts an octal number to binary
OCT2DECConverts an octal number to decimal
OCT2HEXConverts an octal number to hexadecimal
ODDRounds a number up to the nearest odd integer
ODDFPRICEReturns the price per \$100 face value of a security with an odd first period
ODDFYIELDReturns the yield of a security with an odd first period
ODDLPRICEReturns the price per \$100 face value of a security with an odd last period
ODDLYIELDReturns the yield of a security with an odd last period
OFFSETReturns a reference offset from a given reference
ORReturns TRUE if any argument is TRUE
PEARSONReturns the Pearson product moment correlation coefficient
PERCENTILEReturns the k-th percentile of values in a range
PERCENTILE.INCReturns the k-th percentile of values in a range
PERCENTRANKReturns the percentage rank of a value in a data set
PERCENTRANK.INCReturns the percentage rank of a value in a data set
PERMUTReturns the number of permutations for a given number of objects
PHONETICExtracts the phonetic (furigana) characters from a text string
PIReturns the value of pi
PMTReturns the periodic payment for an annuity
POISSONReturns the Poisson distribution
POISSON.DISTReturns the Poisson distribution
POWERReturns the result of a number raised to a power
PPMTReturns the payment on the principal for an investment for a given period
PRICEReturns the price per \$100 face value of a security that pays periodic interest
PRICEDISCReturns the price per \$100 face value of a discounted security
PRICEMATReturns the price per \$100 face value of a security that pays interest at maturity
PROBReturns the probability that values in a range are between two limits
PRODUCTMultiplies its arguments
PROPERCapitalizes the first letter in each word of a text value
PVReturns the present value of an investment
QUARTILEReturns the quartile of a data set
QUARTILE.INCReturns the quartile of a data set
QUOTIENTReturns the integer portion of a division
RANDReturns a random number between 0 and 1
RANDBETWEENReturns a random number between the numbers you specify
RANKReturns the rank of a number in a list of numbers
RANK.EQReturns the rank of a number in a list of numbers
RATEReturns the interest rate per period of an annuity
REGISTER.IDReturns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered
REPLACE, REPLACEBReplaces characters within text
REPTRepeats text a given number of times
RIGHT, RIGHTBReturns the rightmost characters from a text value
ROMANConverts an arabic numeral to roman, as text
ROUNDRounds a number to a specified number of digits
ROUNDDOWNRounds a number down, toward zero
ROUNDUPRounds a number up, away from zero
ROWReturns the row number of a reference
ROWSReturns the number of rows in a reference
RSQReturns the square of the Pearson product moment correlation coefficient
RTDRetrieves real-time data from a program that supports COM automation (Automation: A way to work with an application's objects from another application or development tool. Formerly called OLE Automation, Automation is an industry standard and a feature of the Component Object Model (COM).)
SEARCH, SEARCHBFinds one text value within another (not case-sensitive)
SECONDConverts a serial number to a second
SERIESSUMReturns the sum of a power series based on the formula
SIGNReturns the sign of a number
SINReturns the sine of the given angle
SINHReturns the hyperbolic sine of a number
SKEWReturns the skewness of a distribution
SLNReturns the straight-line depreciation of an asset for one period
SLOPEReturns the slope of the linear regression line
SMALLReturns the k-th smallest value in a data set
SQL.REQUESTConnects with an external data source and runs a query from a worksheet, then returns the result as an array without the need for macro programming
SQRTReturns a positive square root
SQRTPIReturns the square root of (number * pi)
STANDARDIZEReturns a normalized value
STDEVEstimates standard deviation based on a sample
STDEV.PCalculates standard deviation based on the entire population
STDEV.SEstimates standard deviation based on a sample
STDEVAEstimates standard deviation based on a sample, including numbers, text, and logical values
STDEVPCalculates standard deviation based on the entire population
STDEVPACalculates standard deviation based on the entire population, including numbers, text, and logical values
STEYXReturns the standard error of the predicted y-value for each x in the regression
SUBSTITUTESubstitutes new text for old text in a text string
SUBTOTALReturns a subtotal in a list or database
SUMIFAdds the cells specified by a given criteria
SUMPRODUCTReturns the sum of the products of corresponding array components
SUMSQReturns the sum of the squares of the arguments
SUMX2MY2Returns the sum of the difference of squares of corresponding values in two arrays
SUMX2PY2Returns the sum of the sum of squares of corresponding values in two arrays
SUMXMY2Returns the sum of squares of differences of corresponding values in two arrays
SYDReturns the sum-of-years' digits depreciation of an asset for a specified period
TConverts its arguments to text
T.DIST.2TReturns the Percentage Points (probability) for the Student t-distribution
T.DIST.RTReturns the Student's t-distribution
T.INV.2TReturns the inverse of the Student's t-distribution
T.TESTReturns the probability associated with a Student's t-test
TANReturns the tangent of a number
TANHReturns the hyperbolic tangent of a number
TBILLEQReturns the bond-equivalent yield for a Treasury bill
TBILLPRICEReturns the price per \$100 face value for a Treasury bill
TBILLYIELDReturns the yield for a Treasury bill
TDISTReturns the Student's t-distribution
TEXTFormats a number and converts it to text
TIMEReturns the serial number of a particular time
TIMEVALUEConverts a time in the form of text to a serial number
TINVReturns the inverse of the Student's t-distribution
TODAYReturns the serial number of today's date
TRANSPOSEReturns the transpose of an array
TRENDReturns values along a linear trend
TRIMRemoves spaces from text
TRIMMEANReturns the mean of the interior of a data set
TRUEReturns the logical value TRUE
TRUNCTruncates a number to an integer
TTESTReturns the probability associated with a Student's t-test
TYPEReturns a number indicating the data type of a value
UPPERConverts text to uppercase
VALUEConverts a text argument to a number
VAREstimates variance based on a sample
VAR.PCalculates variance based on the entire population
VAR.SEstimates variance based on a sample
VARAEstimates variance based on a sample, including numbers, text, and logical values
VARPCalculates variance based on the entire population
VARPACalculates variance based on the entire population, including numbers, text, and logical values
VDBReturns the depreciation of an asset for a specified or partial period by using a declining balance method
VLOOKUPLooks in the first column of an array and moves across the row to return the value of a cell
WEEKDAYConverts a serial number to a day of the week
WEEKNUMConverts a serial number to a number representing where the week falls numerically with a year
WEIBULLCalculates variance based on the entire population, including numbers, text, and logical values
WEIBULL.DISTReturns the Weibull distribution
WORKDAYReturns the serial number of the date before or after a specified number of workdays
XIRRReturns the internal rate of return for a schedule of cash flows that is not necessarily periodic
XNPVReturns the net present value for a schedule of cash flows that is not necessarily periodic
YEARConverts a serial number to a year
YEARFRACReturns the year fraction representing the number of whole days between start_date and end_date
YIELDReturns the yield on a security that pays periodic interest
YIELDDISCReturns the annual yield for a discounted security; for example, a Treasury bill
YIELDMATReturns the annual yield of a security that pays interest at maturity
Z.TESTReturns the one-tailed probability-value of a z-test
ZTESTReturns the one-tailed probability-value of a z-test