List Of All Excel Formulas or Functions

124

List Of All Excel Formulas or Functions

 

Download vlookup formula here

Excel Function name

Description of Excel Function

CALL functionCalls a procedure in a dynamic link library or code resource
EUROCONVERT functionConverts 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).
REGISTER.ID functionReturns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered
SQL.REQUEST functionConnects 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
BETADIST functionIt eturns the beta cumulative distribution function In Excel 2007. This is a Statistical function used for statistical operations
BETAINV functionReturns the inverse of the cumulative distribution function for a specified beta distribution
CHIDIST functionReturns the one-tailed probability of the chi-squared distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
CHIINV functionReturns the inverse of the one-tailed probability of the chi-squared distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
CHITEST functionReturns the test for independence. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
CONFIDENCE functionReturns the confidence interval for a population mean. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
COVAR functionReturns covariance, the average of the products of paired deviations. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
CRITBINOM functionReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
EXPONDIST functionReturns the exponential distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
FDIST functionReturns the F probability distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
FLOOR functionRounds a number down, toward zero. This is the newly added function from 2007 Excel version and this is very useful Excel formula for  Mathametical and trigonometrical operations
FTEST functionReturns the result of an F-test. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
GAMMADIST functionReturns the gamma distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
GAMMAINV functionReturns the inverse of the gamma cumulative distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
HYPGEOMDIST functionReturns the hypergeometric distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
LOGINV functionReturns the inverse of the lognormal cumulative distribution
LOGNORMDIST functionReturns the cumulative lognormal distribution
MODE functionReturns the most common value in a data set. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
NEGBINOMDIST functionReturns the negative binomial distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
NORMDIST functionReturns the normal cumulative distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
NORM.INV functionReturns the inverse of the normal cumulative distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
NORMSDIST functionReturns the standard normal cumulative distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
NORMSINV functionReturns the inverse of the standard normal cumulative distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
PERCENTILE functionReturns the k-th percentile of values in a range2. This  is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
PERCENTRANK functionReturns the percentage rank of a value in a data set. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
POISSON functionReturns the Poisson distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
QUARTILE functionReturns the quartile of a data set. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
RANK functionReturns the rank of a number in a list of numbers. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
STDEV functionEstimates standard deviation based on a sample
STDEVP functionCalculates standard deviation based on the entire population. is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
TDIST functionReturns the Student’s t-distribution
TINV functionThis function quite opposite to TDIST function. It returns the inverse of TDIST Student’s Tdistribution
TTEST functionReturns the probability associated with a Student’s t-test. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
VAR functionEstimates variance based on a sample. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
VARP functionCalculates variance based on the entire population. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
WEIBULL functionThis function calculates variance based on the all population, even includes numbers, text, and logical values as well. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
ZTEST functionReturns the one-tailed probability-value of a z-test.This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
CUBEKPIMEMBER functionReturns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization’s performance.
CUBEMEMBER functionReturns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube.
CUBEMEMBERPROPERTY functionReturns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member.
CUBERANKEDMEMBER functionReturns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students.
CUBESET functionDefines a calculated set of members or tuples through sending a fixed expression to the cube at the server, which creates the set, after which returns that set to Microsoft Office Excel
CUBESETCOUNT functionNumber of items in the given set can be returned
CUBEVALUE functionAggregated vlaue of the cube can be returned by this function
DAVERAGE functionReturns the average of selected database entries
DCOUNT functionCounts the cells that contain numbers in a database
DCOUNTA functionCounts nonblank cells in a database
DGET functionExtracts from a database a single record that matches the specified criteria
DMAX functionReturns the maximum value from selected database entries
DMIN functionReturns the minimum value from selected database entries
DPRODUCT functionMultiplies the values in a particular field of records that match the criteria in a database
DSTDEV functionEstimates the standard deviation based on a sample of selected database entries
DSTDEVP functionCalculates the standard deviation based on the entire population of selected database entries
DSUM functionAdds the numbers in the field column of records in the database that match the criteria
DVAR functionEstimates variance based on a sample from selected database entries
DVARP functionCalculates variance based on the entire population of selected database entries
DATE functionReturns the serial number of a particular date
DATEDIF functionCalculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age.
DATEVALUE functionConverts a date in the form of text to a serial number
DAY functionConverts a serial number to a day of the month
DAYS functionReturns the number of days between two dates
DAYS360 functionCalculates the number of days between two dates based on a 360-day year
EDATE functionReturns the serial number of the date that is the indicated number of months before or after the start date
EOMONTH functionReturns the serial number of the last day of the month before or after a specified number of months
HOUR functionConverts a serial number to an hour
ISOWEEKNUM functionReturns the number of the ISO week number of the year for a given date
MINUTE functionConverts a serial number to a minute
MONTH functionConverts a serial number to a month
NETWORKDAYS functionReturns the number of whole workdays between two dates
NETWORKDAYS.INTL functionReturns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days
NOW functionReturns the serial number of the current date and time
SECOND functionConverts a serial number to a second
TIME functionReturns the serial number of a particular time
TIMEVALUE functionConverts a time in the form of text to a serial number
TODAY functionReturns the serial number of today’s date
WEEKDAY functionConverts a serial number to a day of the week
WEEKNUM functionConverts a serial number to a number representing where the week falls numerically with a year
WORKDAY functionReturns the serial number of the date before or after a specified number of workdays
WORKDAY.INTL functionReturns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days
YEAR functionConverts a serial number to a year
YEARFRAC functionReturns the year fraction representing the number of whole days between start_date and end_date
BESSELI functionReturns the modified Bessel function In(x)
BESSELJ functionReturns the Bessel function Jn(x)
BESSELK functionReturns the modified Bessel function Kn(x)
BESSELY functionReturns the Bessel function Yn(x)
BIN2DEC functionConverts a binary number to decimal
BIN2HEX functionConverts a binary number to hexadecimal
BIN2OCT functionConverts a binary number to octal
BITAND functionReturns a ‘Bitwise And’ of two numbers
BITLSHIFT functionReturns a value number shifted left by shift_amount bits
BITOR functionReturns a bitwise OR of 2 numbers
BITRSHIFT functionReturns a value number shifted right by shift_amount bits
BITXOR functionReturns a bitwise ‘Exclusive Or’ of two numbers
COMPLEX functionConverts real and imaginary coefficients into a complex number
CONVERT functionConverts a number from one measurement system to another
DEC2BIN functionConverts a decimal number to binary
DEC2HEX functionConverts a decimal number to hexadecimal
DEC2OCT functionConverts a decimal number to octal
DELTA functionTests whether two values are equal
ERF functionReturns the error function
ERF.PRECISE functionReturns the error function
ERFC functionReturns the complementary error function
ERFC.PRECISE functionReturns the complementary ERF function integrated between x and infinity
GESTEP functionTests whether a number is greater than a threshold value
HEX2BIN functionConverts a hexadecimal number to binary
HEX2DEC functionConverts a hexadecimal number to decimal
HEX2OCT functionConverts a hexadecimal number to octal
IMABS functionReturns the absolute value (modulus) of a complex number
IMAGINARY functionReturns the imaginary coefficient of a complex number
IMARGUMENT functionReturns the argument theta, an angle expressed in radians
IMCONJUGATE functionReturns the complex conjugate of a complex number
IMCOS functionReturns the cosine of a complex number
IMCOSH functionReturns the hyperbolic cosine of a complex number
IMCOT functionReturns the cotangent of a complex number
IMCSC functionReturns the cosecant of a complex number
IMCSCH functionReturns the hyperbolic cosecant of a complex number
IMDIV functionReturns the quotient of two complex numbers
IMEXP functionReturns the exponential of a complex number
IMLN functionReturns the natural logarithm of a complex number
IMLOG10 functionReturns the base-10 logarithm of a complex number
IMLOG2 functionReturns the base-2 logarithm of a complex number
IMPOWER functionReturns a complex number raised to an integer power
IMPRODUCT functionReturns the product of complex numbers
IMREAL functionReturns the real coefficient of a complex number
IMSEC functionReturns the secant of a complex number
IMSECH functionReturns the hyperbolic secant of a complex number
IMSIN functionReturns the sine of a complex number
IMSINH functionReturns the hyperbolic sine of a complex number
IMSQRT functionReturns the square root of a complex number
IMSUB functionReturns the difference between two complex numbers
IMSUM functionReturns the sum of complex numbers
IMTAN functionReturns the tangent of a complex number
OCT2BIN functionConverts an octal number to binary
OCT2DEC functionConverts an octal number to decimal
OCT2HEX functionConverts an octal number to hexadecimal
ACCRINT functionReturns the accrued interest for a security that pays periodic interest
ACCRINTM functionReturns the accrued interest for a security that pays interest at maturity
AMORDEGRC functionReturns the depreciation for each accounting period by using a depreciation coefficient
AMORLINC functionReturns the depreciation for each accounting period
COUPDAYBS functionReturns the number of days from the beginning of the coupon period to the settlement date
COUPDAYS functionReturns the number of days in the coupon period that contains the settlement date
COUPDAYSNC functionReturns the number of days from the settlement date to the next coupon date
COUPNCD functionReturns the next coupon date after the settlement date
COUPNUM functionReturns the number of coupons payable between the settlement date and maturity date
COUPPCD functionReturns the previous coupon date before the settlement date
CUMIPMT functionReturns the cumulative interest paid between two periods
CUMPRINC functionReturns the cumulative principal paid on a loan between two periods
DB functionReturns the depreciation of an asset for a specified period by using the fixed-declining balance method
DDB functionReturns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify
DISC functionReturns the discount rate for a security
DOLLARDE functionConverts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number
DOLLARFR functionConverts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction
DURATION functionReturns the annual duration of a security with periodic interest payments
EFFECT functionReturns the effective annual interest rate
FV functionReturns the future value of an investment
FVSCHEDULE functionReturns the future value of an initial principal after applying a series of compound interest rates
INTRATE functionReturns the interest rate for a fully invested security
IPMT functionReturns the interest payment for an investment for a given period
IRR functionReturns the internal rate of return for a series of cash flows
ISPMT functionCalculates the interest paid during a specific period of an investment
MDURATION functionReturns the Macauley modified duration for a security with an assumed par value of $100
MIRR functionReturns the internal rate of return where positive and negative cash flows are financed at different rates
NOMINAL functionReturns the annual nominal interest rate
NPER functionReturns the number of periods for an investment
NPV functionReturns the net present value of an investment based on a series of periodic cash flows and a discount rate
ODDFPRICE functionReturns the price per $100 face value of a security with an odd first period
ODDFYIELD functionReturns the yield of a security with an odd first period
ODDLPRICE functionReturns the price per $100 face value of a security with an odd last period
ODDLYIELD functionReturns the yield of a security with an odd last period
PDURATION functionReturns the number of periods required by an investment to reach a specified value
PMT functionReturns the periodic payment for an annuity
PPMT functionReturns the payment on the principal for an investment for a given period
PRICE functionReturns the price per $100 face value of a security that pays periodic interest
PRICEDISC functionReturns the price per $100 face value of a discounted security
PRICEMAT functionReturns the price per $100 face value of a security that pays interest at maturity
PV functionReturns the present value of an investment
RATE functionReturns the interest rate per period of an annuity
RECEIVED functionReturns the amount received at maturity for a fully invested security
RRI functionReturns an equivalent interest rate for the growth of an investment
SLN functionReturns the straight-line depreciation of an asset for one period
SYD functionReturns the sum-of-years’ digits depreciation of an asset for a specified period
TBILLEQ functionReturns the bond-equivalent yield for a Treasury bill
TBILLPRICE functionReturns the price per $100 face value for a Treasury bill
TBILLYIELD functionReturns the yield for a Treasury bill
VDB functionReturns the depreciation of an asset for a specified or partial period by using a declining balance method
XIRR functionReturns the internal rate of return for a schedule of cash flows that is not necessarily periodic
XNPV functionReturns the net present value for a schedule of cash flows that is not necessarily periodic
YIELD functionReturns the yield on a security that pays periodic interest
YIELDDISC functionReturns the annual yield for a discounted security; for example, a Treasury bill
YIELDMAT functionReturns the annual yield of a security that pays interest at maturity
CELL functionReturns information about the formatting, location, or contents of a cell. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
ERROR.TYPE functionReturns a number corresponding to an error type
INFO functionReturns information about the current operating environment. This function returns the current opration environment
ISBLANK functionReturns TRUE if the value is blank
ISERR functionReturns TRUE if the value is any error value except #N/A
ISERROR functionReturns TRUE if the value is any error value
ISEVEN functionReturns TRUE if the number is even
ISFORMULA functionReturns TRUE if there is a reference to a cell that contains a formula
ISLOGICAL functionReturns TRUE if the value is a logical value
ISNA functionReturns TRUE if the value is the #N/A error value
ISNONTEXT functionReturns TRUE if the value is not text
ISNUMBER functionReturns TRUE if the value is a number
ISODD functionReturns TRUE if the number is odd
ISREF functionReturns TRUE if the value is a reference
ISTEXT functionReturns TRUE if the value is text
N functionReturns a value converted to a number
NA functionReturns the error value #N/A
SHEET functionReturns the sheet number of the referenced sheet
SHEETS functionReturns the number of sheets in a reference
TYPE functionReturns a number indicating the data type of a value
AND functionReturns TRUE if all of its arguments are TRUE
FALSE functionReturns the logical value FALSE
IF functionSpecifies a logical test to perform
IFERROR functionReturns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula
IFNA functionReturns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression
IFS functionChecks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.This  function is not implimented in the Mac version
NOT functionReverses the logic of its argument
OR functionReturns TRUE if any argument is TRUE
SWITCH functionEvaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. This function isn’t available in Excel 2016 for Mac.
TRUE functionReturns the logical value TRUE
XOR functionReturns a logical exclusive OR of all arguments
ADDRESS functionReturns a reference as text to a single cell in a worksheet
CHOOSE functionChooses a value from a list of values
COLUMN functionReturns the column number of a reference
COLUMNS functionReturns the number of columns in a reference
FORMULATEXT functionReturns the formula at the given reference as text
GETPIVOTDATA functionReturns data stored in a PivotTable report
HLOOKUP functionLooks in the top row of an array and returns the value of the indicated cell
HYPERLINK functionCreates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
INDEX functionUses an index to choose a value from a reference or array
INDIRECT functionReturns a reference indicated by a text value
LOOKUP functionLooks up values in a vector or array
MATCH functionLooks up values in a reference or array
OFFSET functionReturns a reference offset from a given reference
ROW functionReturns the row number of a reference
ROWS functionReturns the number of rows in a reference
RTD functionRetrieves real-time data from a program that supports COM automation
TRANSPOSE functionReturns the transpose of an array
VLOOKUP functionLooks in the first column of an array and moves across the row to return the value of a cell
ACOS functionThis function returns the arccosine number of the given number
ACOSH functionReturns the inverse hyperbolic cosine of a number. Since this is a trigonometrical function. We can use this in such operations
ACOT functionReturns the arccotangent of a number
ACOTH functionReturns the hyperbolic arccotangent of a number
AGGREGATE functionReturns an aggregate in a list or database
ARABIC functionConverts a Roman number to Arabic, as a number
BASE functionConverts a number into a text representation with the given radix (base)
CEILING functionRounds a number to the nearest integer or to the nearest multiple of significance
CEILING.MATH functionRounds a number up, to the nearest integer or to the nearest multiple of significance
CEILING.PRECISE functionRounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
COMBIN functionReturns the number of combinations for a given number of objects. Returns the number of combinations with repetitions for a given number of items
COS functionReturns the cosine of a number
COSH functionReturns the hyperbolic cosine of a number
COT functionReturns the hyperbolic cosine of a number
COTH functionReturns the cotangent of an angle
CSC functionReturns the cosecant of an angle
CSCH functionReturns the hyperbolic cosecant of an angle
DECIMAL functionConverts a text representation of a number in a given base into a decimal number
DEGREES functionConverts radians to degrees
EVEN functionRounds a number up to the nearest even integer
EXP functionReturns e raised to the power of a given number
FACT functionReturns the factorial of a number
FACTDOUBLE functionReturns the double factorial of a number
FLOOR.MATH functionRounds a number down, to the nearest integer or to the nearest multiple of significance
FLOOR.PRECISE functionRounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
GCD functionReturns the greatest common divisor
INT functionRounds a number down to the nearest integer
ISO.CEILING functionReturns a number that is rounded up to the nearest integer or to the nearest multiple of significance
LCM functionReturns the least common multiple
LN functionReturns the natural logarithm of a number
LOG functionReturns the logarithm of a number to a specified base
LOG10 functionReturns the base-10 logarithm of a number
MDETERM functionReturns the matrix determinant of an array
MINVERSE functionReturns the matrix inverse of an array
MMULT functionReturns the matrix product of two arrays
MOD functionReturns the remainder from division
MROUND functionReturns a number rounded to the desired multiple
MULTINOMIAL functionReturns the multinomial of a set of numbers
MUNIT functionReturns the unit matrix or the specified dimension
ODD functionRounds a number up to the nearest odd integer
PI functionReturns the value of pi
POWER functionReturns the result of a number raised to a power
PRODUCT functionMultiplies its arguments
QUOTIENT functionReturns the integer portion of a division
RADIANS functionConverts degrees to radians
RAND functionReturns a random number between 0 and 1
RANDBETWEEN functionReturns a random number between the numbers you specify
ROMAN functionConverts an arabic numeral to roman, as text
ROUND functionRounds a number to a specified number of digits
ROUNDDOWN functionRounds a number down, toward zero
ROUNDUP functionRounds a number up, away from zero
SEC functionReturns the secant of an angle
SECH functionReturns the hyperbolic secant of an angle
SERIESSUM functionReturns the sum of a power series based on the formula
SIGN functionReturns the sign of a number
SIN functionReturns the sine of the given angle
SINH functionReturns the hyperbolic sine of a number
SQRT functionReturns a positive square root
SQRTPI functionReturns the square root of (number * pi)
SUBTOTAL functionReturns a subtotal in a list or database
SUM functionAdds its arguments
SUMIF functionAdds the cells specified by a given criteria
SUMIFS functionAdds the cells in a range that meet multiple criteria
SUMPRODUCT functionReturns the sum of the products of corresponding array components
SUMSQ functionReturns the sum of the squares of the arguments
SUMX2MY2 functionReturns the sum of the difference of squares of corresponding values in two arrays
SUMX2PY2 functionReturns the sum of the sum of squares of corresponding values in two arrays
SUMXMY2 functionReturns the sum of squares of differences of corresponding values in two arrays
TAN functionReturns the tangent of a number
TANH functionReturns the hyperbolic tangent of a number
TRUNC functionTruncates a number to an integer
ABS functionABS Funtion returns only the positive value
AVERAGE functionReturns the average of its arguments
AVERAGEA functionReturns the average of its arguments, including numbers, text, and logical values
AVERAGEIF functionReturns the average (arithmetic mean) of all the cells in a range that meet a given criteria
AVERAGEIFS functionReturns the average (arithmetic mean) of all cells that meet multiple criteria.
BETA.DIST functionReturns the beta cumulative distribution function
BETA.INV functionThis is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
BINOM.DIST functionReturns the individual term binomial distribution probability
BINOM.DIST.RANGE functionReturns the probability of a trial result using a binomial distribution
BINOM.INV functionReturns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
CHISQ.DIST functionReturns the cumulative beta probability density function
CHISQ.DIST.RT functionReturns the one-tailed probability of the chi-squared distribution
CHISQ.INV functionReturns the cumulative beta probability density function
CHISQ.INV.RT functionReturns the inverse of the one-tailed probability of the chi-squared distribution
CHISQ.TEST functionReturns the test for independence
CONFIDENCE.NORM functionReturns the confidence interval for a population mean
CONFIDENCE.T functionReturns the confidence interval for a population mean, using a Student’s t distribution
CORREL functionReturns the correlation coefficient between two data sets
COUNT functionCounts how many numbers are in the list of arguments
COUNTA functionCounts how many values are in the list of arguments
COUNTBLANK functionCounts the number of blank cells within a range
COUNTIF functionCounts the number of cells within a range that meet the given criteria
COUNTIFS functionCounts the number of cells within a range that meet multiple criteria
COVARIANCE.P functionReturns covariance, the average of the products of paired deviations
COVARIANCE.S functionReturns the sample covariance, the average of the products deviations for each data point pair in two data sets
DEVSQ functionReturns the sum of squares of deviations
EXPON.DIST functionReturns the exponential distribution
F.DIST functionReturns the F probability distribution
F.DIST.RT functionReturns the F probability distribution
F.INV functionReturns the inverse of the F probability distribution
F.INV.RT functionReturns the inverse of the F probability distribution
FINV functionReturns the inverse of the F probability distribution
FISHER functionReturns the Fisher transformation
FISHERINV functionReturns the inverse of the Fisher transformation
FORECAST functionReturns a value along a linear trend. This formula was updated in the 2016 Excel version , this function was changed as FORECAST.LINEAR Still this function is available in the previous versions
FORECAST.ETS functionReturns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm
FORECAST.ETS.CONFINT functionReturns a confidence interval for the forecast value at the specified target date
FORECAST.ETS.SEASONALITY functionReturns the length of the repetitive pattern Excel detects for the specified time series
FORECAST.ETS.STAT functionReturns a statistical value as a result of time series forecasting
FORECAST.LINEAR functionReturns a future value based on existing values
FREQUENCY functionReturns a frequency distribution as a vertical array
F.TEST functionReturns the result of an F-test
GAMMA functionReturns the Gamma function value
GAMMA.DIST functionReturns the gamma distribution
GAMMA.INV functionReturns the inverse of the gamma cumulative distribution
GAMMALN functionReturns the natural logarithm of the gamma function, Γ(x)
GAMMALN.PRECISE functionReturns the natural logarithm of the gamma function, Γ(x)
GAUSS functionReturns 0.5 less than the standard normal cumulative distribution
GEOMEAN functionReturns the geometric mean
GROWTH functionReturns values along an exponential trend
HARMEAN functionReturns the harmonic mean
HYPGEOM.DIST functionReturns the hypergeometric distribution
INTERCEPT functionReturns the intercept of the linear regression line
KURT functionReturns the kurtosis of a data set
LARGE functionReturns the k-th largest value in a data set
LINEST functionReturns the parameters of a linear trend
LOGEST functionReturns the parameters of an exponential trend
LOGNORM.DIST functionReturns the cumulative lognormal distribution
LOGNORM.INV functionReturns the inverse of the lognormal cumulative distribution
MAX functionReturns the maximum value in a list of arguments
MAXA functionReturns the maximum value in a list of arguments, including numbers, text, and logical values
MAXIFS functionReturns the maximum value among cells specified by a given set of conditions or criteria
MEDIAN functionReturns the median of the given numbers
MIN functionReturns the minimum value in a list of arguments
MINIFS functionReturns the minimum value among cells specified by a given set of conditions or criteria.
MINA functionReturns the smallest value in a list of arguments, including numbers, text, and logical values
MODE.MULT functionReturns a vertical array of the most frequently occurring, or repetitive values in an array or range of data
MODE.SNGL functionReturns the most common value in a data set
NEGBINOM.DIST functionReturns the negative binomial distribution
NORM.DIST functionReturns the normal cumulative distribution
NORMINV functionReturns the inverse of the normal cumulative distribution
NORM.S.DIST functionReturns the standard normal cumulative distribution
NORM.S.INV functionReturns the inverse of the standard normal cumulative distribution
PEARSON functionReturns the Pearson product moment correlation coefficient
PERCENTILE.EXC functionReturns the k-th percentile of values in a range, where k is in the range 0..1, exclusive
PERCENTILE.INC functionReturns the k-th percentile of values in a range
PERCENTRANK.EXC functionReturns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set
PERCENTRANK.INC functionReturns the percentage rank of a value in a data set
PERMUT functionReturns the number of permutations for a given number of objects
PERMUTATIONA functionReturns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects
PHI functionReturns the value of the density function for a standard normal distribution
POISSON.DIST functionReturns the Poisson distribution
PROB functionReturns the probability that values in a range are between two limits
QUARTILE.EXC functionReturns the quartile of the data set, based on percentile values from 0..1, exclusive
QUARTILE.INC functionReturns the quartile of a data set
RANK.AVG functionReturns the rank of a number in a list of numbers
RANK.EQ functionReturns the rank of a number in a list of numbers
RSQ functionReturns the square of the Pearson product moment correlation coefficient
SKEW functionReturns the skewness of a distribution
SKEW.P functionReturns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean
SLOPE functionReturns the slope of the linear regression line
SMALL functionReturns the k-th smallest value in a data set
STANDARDIZE functionReturns a normalized value
STDEV.P functionCalculates standard deviation based on the entire population
STDEV.S functionEstimates standard deviation based on a sample
STDEVA functionEstimates standard deviation based on a sample, including numbers, text, and logical values
STDEVPA functionCalculates standard deviation based on the entire population, including numbers, text, and logical values
STEYX functionReturns the standard error of the predicted y-value for each x in the regression
T.DIST functionReturns the Percentage Points (probability) for the Student t-distribution
T.DIST.2T functionReturns the Percentage Points (probability) for the Student t-distribution
T.DIST.RT functionReturns the Student’s t-distribution
T.INV functionReturns the t-value of the Student’s t-distribution as a function of the probability and the degrees of freedom
T.INV.2T functionReturns the inverse of the Student’s t-distribution
TREND functionReturns values along a linear trend
TRIMMEAN functionReturns the mean of the interior of a data set
T.TEST functionReturns the probability associated with a Student’s t-test
VAR.P functionCalculates variance based on the entire population
VAR.S functionEstimates variance based on a sample
VARA functionEstimates variance based on a sample, including numbers, text, and logical values
VARPA functionCalculates variance based on the entire population, including numbers, text, and logical values
WEIBULL.DIST functionReturns the Weibull distribution
Z.TEST functionReturns the one-tailed probability-value of a z-test
BAHTTEXT functionConverts a number to text, using the ß (baht) currency format
CHAR functionReturns the character specified by the code number
CLEAN functionRemoves all nonprintable characters from text
CODE functionReturns a numeric code for the first character in a text string
CONCAT functionCombines the text from multiple ranges and/or strings, but it doesn’t provide the delimiter or IgnoreEmpty arguments.
CONCATENATE functionJoins several text items into one text item
DBCS functionChanges half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters
DOLLAR functionConverts a number to text, using the $ (dollar) currency format
EXACT functionChecks to see if two text values are identical
FIND, FINDB functionsFinds one text value within another (case-sensitive)
FIXED functionFormats a number as text with a fixed number of decimals
JIS functionhanges half-width (single-byte) characters within a string to full-width (double-byte) characters
LEFT, LEFTB functionsReturns the leftmost characters from a text value
LEN, LENB functionsReturns the number of characters in a text string
LOWER functionConverts text to lowercase
MID, MIDB functionsReturns a specific number of characters from a text string starting at the position you specify
NUMBERVALUE functionConverts text to number in a locale-independent manner
PHONETIC functionExtracts the phonetic (furigana) characters from a text string
PROPER functionCapitalizes the first letter in each word of a text value
REPLACE, REPLACEB functionsReplaces characters within text
REPT functionRepeats text a given number of times
RIGHT, RIGHTB functionsReturns the rightmost characters from a text value
SEARCH, SEARCHB functionsFinds one text value within another (not case-sensitive)
SUBSTITUTE functionSubstitutes new text for old text in a text string
T functionConverts its arguments to text
TEXT functionFormats a number and converts it to text
TEXTJOIN functionCombines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.
TRIM functionRemoves spaces from text
UNICHAR functionReturns the Unicode character that is references by the given numeric value
UNICODE functionReturns the number (code point) that corresponds to the first character of the text
UPPER functionConverts text to uppercase
VALUE functionConverts a text argument to a number
ENCODEURL functionReturns a URL-encoded string. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
FILTERXML functionReturns specific data from the XML content by using the specified Xpath. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
WEBSERVICE functionReturns data from a web service. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations

124 COMMENTS

  1. It is the best time to make some plans for the future and it is time
    to be happy. I have read this post and if I could I desire to suggest
    you some interesting things or suggestions.
    Maybe you can write next articles referring to this article.

    I desire to read even more things about it!

  2. If will need permanent writers, then you have to go to any
    job sites and working as a consultant. Innumerable web pages are being produced and
    being hosted everyday. Thanks to Kim to adding for the high quality of
    writers here

  3. Publish will have more give you an idea about the exact information that they may be looking for.

    The lyrics will seem as if they just flow at a mind and into the word processor.

  4. I am not sure where you’re getting your info, but good topic.
    I needs to spend some time learning much more or understanding more.
    Thanks for excellent information I was looking for this information for my mission.

  5. Hey there would you mind sharing which blog platform you’re working with?

    I’m looking to start my own blog in the near future but I’m having a tough time selecting between BlogEngine/Wordpress/B2evolution and Drupal.
    The reason I ask is because your design and style seems
    different then most blogs and I’m looking for something unique.
    P.S Sorry for getting off-topic but I had to

  6. I was suggested this web site by way of my cousin. I am now not certain whether this put up is written by him as
    nobody else know such distinctive about my trouble. You’re incredible!

    Thanks!

  7. I’ve been browsing online more than three hours today, yet I never found any
    interesting article like yours. It’s pretty worth
    enough for me. In my opinion, if all site owners and bloggers made good content as you did, the internet will be a
    lot more useful than ever before.

  8. Great work! That is the kind of info that should
    be shared across the web. Disgrace on the seek engines for not
    positioning this publish upper! Come on over and visit my website .
    Thanks =)

  9. First off I want to say terrific blog! I had a quick question which I’d like to ask if you do
    not mind. I was curious to know how you center yourself and clear your mind prior to writing.
    I have had a tough time clearing my mind in getting my thoughts out there.
    I do enjoy writing however it just seems like the first 10 to 15 minutes
    are generally wasted simply just trying to figure out how to
    begin. Any recommendations or tips? Kudos!

    • Thank you very much for visiting my blog. See when you want to write the article first keep the information in mind and switch of the internet and starting writing the content until you unload the info from your mind in word document. Then you get the excellent content for the article. Daily you keep the habit to think about the relevant topic which suits to your blog. And start writing. Then your blog would be filled with hundreds of articles like this List of Excel formula kind of stuff. Hope you understand. If you still need clarity, you can comment again

  10. Howdy! This is my first visit to your blog! We are a collection of volunteers
    and starting a new project in a community in the same niche.

    Your blog provided us beneficial information to work
    on. You have done a extraordinary job!

  11. Its like you read my mind! You appear to know so much
    about this, like you wrote the book in it or something.
    I think that you can do with some pics to drive the message home a bit, but instead of
    that, this is great blog. A great read. I’ll certainly be back.

  12. I really like your blog.
    Very nice colors and Amp. theme
    Did you create this?
    Website yourself or did you hire someone to do it for you?
    Please answer back as I am looking to create my own blog and would like to find out where you got
    this from. thank you

  13. Thanks for your personal marvelous posting! I certainly
    enjoyed reading it, you happen to be a great author.
    I will always bookmark your blog and may come back very
    soon. I want to encourage you to continue your great writing, have
    a nice holiday weekend!

  14. Thanks for your personal marvelous posting! I definitely enjoyed reading it, you could be
    a great author. I will ensure that I bookmark your blog and definitely will
    come back down the road. I want to encourage yourself to continue your great posts,
    have a nice afternoon!

  15. I blog quite often and I seriously appreciate your information.
    This article has really peaked my interest. I’m going to bookmark your website and keep checking for new
    information about once per week. I opted in for your Feed
    too.

  16. You could definitely see your skills within the work you write.
    The arena hopes for more passionate writers such as you who aren’t afraid
    to say how they believe. At all times follow your heart.

  17. We are a group of volunteers and starting a brand new scheme in our community.
    Your web site offered us with helpful information to work on. You
    have performed a formidable task and our whole group can be thankful to
    you.

  18. I was studying this blog from many months, which is rapidly providing much knowledge for visitors on excel vlookup kind of formulas in Excel. Also i am just wondering to learn VBA programming using your blog. Please write more articles on VBA programming related topics. We are waiting eagerly to study. Hope we get new articles on VBA programming soon.

    • I will surely provide you more articles on VBA programming too. Stay tuned. Thanks for your response on my blog articles. I would expect more idea like these to provide you more articles on various topics about excel, VBA programming

  19. You have given all the list of excel formulas in this article to learn by visitors which is great help. Also we are watching your blog on daily basis to learn new tricks and formulas in excel. It is very professional blog which is rapidly growing in the online world. I think lot of people would visit your blog to learn Excel and VBA programming.

    • Sure!!!. I will provide you more information through my blog. And I am very happy that you are vising frequently to learn Excel and VBA programming

  20. You have shared your experience with Excel in your blog, which is very valuable for visitors to learn excel formulas and VBA programming in the online from your website. This blog is user friendly. Please provide more information on daily basis as many people are getting much knowledge from your wonderful blog. Looking forward many articles from your website on daily basis.

  21. Great post. I was checking continuously this blog and I’m impressed!
    Extremely useful info particularly the last part 🙂 I care
    for such information much. I was seeking this certain info for a
    long time. Thank you and best of luck.

LEAVE A REPLY

Please enter your comment!
Please enter your name here