Excel Functions

All Excel Functions

Add-in and Automation   Compatibility Cube Database

 

CALL function Calls a procedure in a dynamic link library or code resource which is very useful function in vba macros Download Example
EUROCONVERT function Converts 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 function Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered
SQL.REQUEST function Connects 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

 

BETA.DIST function It returns the beta cumulative distribution function In Excel 2007. This is a Statistical function used for statistical operations
BETAINV function Returns the inverse of the cumulative distribution function for a specified beta distribution
CHIDIST function Returns 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 function Returns 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 function Returns the test for independence. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
CONFIDENCE function Returns 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 function Returns 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 function Returns 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 function Returns the exponential distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
FDIST function Returns the F probability distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
FLOOR function Rounds 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 function Returns 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 function Returns the gamma distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
GAMMAINV function Returns 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 function Returns the hypergeometric distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
LOGINV function Returns the inverse of the lognormal cumulative distribution
LOGNORMDIST function Returns the cumulative lognormal distribution
MODE function Returns 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 function Returns the negative binomial distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
NORMDIST function Returns 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 function Returns 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 function Returns 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 function Returns 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 function Returns 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 function Returns 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 function Returns the Poisson distribution. This is the newly added function in the 2007 Excel version and This formula is very useful Statistical operations
QUARTILE function Returns 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 function Returns 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 function Estimates standard deviation based on a sample
STDEVP function Calculates 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 function Returns the Student’s t-distribution
TINV function This function quite opposite to TDIST function. It returns the inverse of TDIST Student’s Tdistribution
TTEST function Returns 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 function Estimates 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 function Calculates 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 function This 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 function Returns 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 function This function is for Key performance indicator it gives full details of that particular KPI measurements like monthly gross profit or turnover of the employee as such would returned by this
CUBEMEMBER function Returns a member or tuple in a cube hierarchy. It checks whether the member or tuple is avaialable in the cube
CUBEMEMBERPROPERTY function Returns the value of a member property in the cube. It verify whether member is there or not. If member is there then the specified property of member would be returned
CUBERANKEDMEMBER function Returns the nth, or ranked, member in a set. It provide the single or multi elements in a set like highest sales or highly performed or top 10 stundents
CUBESET function This would be used for sending the caculated set to of member to fixed expression in the server and it returns the set to microsoft office
CUBESETCOUNT function Number of items in the given set can be returned
CUBEVALUE function Aggregated vlaue of the cube can be returned by this function

DAVERAGE function Returns the not unusual of hand-picked info entries
DCOUNT function Counts the cells that comprise numbers in a totally data
DCOUNTA function Counts nonblank cells in a totally data
DGET function Extracts from a information one file that fits the desired standards
DMAX function Returns the maximum charge from hand-picked data entries
DMIN function Returns the minimal price from hand-picked data entries
DPRODUCT function Multiplies the values in a totally particular discipline of records that fit the requirements in a totally information
DSTDEV function Estimates the pleasant deviation supported a sample of hand-picked info entries
DSTDEVP function Calculates the great deviation supported the complete populace of hand-picked info entries
DSUM function Adds the numbers in the field column of information inside the information that in shape the requirements
DVAR function Estimates variance supported a pattern from hand-picked information entries
DVARP function It provides the Variance of the given population

6 COMMENTS

  1. Great post. I used to be checking continuously this weblog and I’m
    impressed! Extremely helpful information particularly the remaining section 🙂 I deal with such info a lot.
    I used to be looking for this certain info for a very long time.
    Thanks and good luck.

  2. Hey there, You’ve done a fanastic job. I will certainly dihg it annd personally suggest to my
    friends. I am confident they’ll be benefited from this web site.

LEAVE A REPLY

Please enter your comment!
Please enter your name here