Functions

All Excel Functions

Add-in and Automation  Compatibility Cube Database

CALL functionCalls a procedure in a dynamic link library or code resource which is very useful function in vba macros
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

BETA.DIST functionIt returns 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 functionThis 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 functionReturns a member or tuple in a cube hierarchy. It checks whether the member or tuple is avaialable in the cube
CUBEMEMBERPROPERTY functionReturns 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 functionReturns 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 functionThis 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 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 not unusual of hand-picked info entries
DCOUNT functionCounts the cells that comprise numbers in a totally data
DCOUNTA functionCounts nonblank cells in a totally data
DGET functionExtracts from a information one file that fits the desired standards
DMAX functionReturns the maximum charge from hand-picked data entries
DMIN functionReturns the minimal price from hand-picked data entries
DPRODUCT functionMultiplies the values in a totally particular discipline of records that fit the requirements in a totally information
DSTDEV functionEstimates the pleasant deviation supported a sample of hand-picked info entries
DSTDEVP functionCalculates the great deviation supported the complete populace of hand-picked info entries
DSUM functionAdds the numbers in the field column of information inside the information that in shape the requirements
DVAR functionEstimates variance supported a pattern from hand-picked information entries
DVARP functionIt provides the Variance of the given population

3 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here