# 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 |

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 |

I got good info from your blog

Thank you very much. I am really happy with your comments and giving boost to write more articles like this

I want to thank you for this very good read!! I certainly enjoyed every bit

of it. I have got you bookmarked to look at new things you

post…