Enum Excel2007Function
Represents functions added in Excel 2007.
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public enum Excel2007FunctionFields
| Name | Description |
|---|---|
| AVERAGEIF | Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria |
| AVERAGEIFS | Returns the average (arithmetic mean) of all cells that meet multiple criteria. |
| BESSELI | Returns the modified Bessel function In(x). |
| BESSELJ | Returns the Bessel function Jn(x). |
| BESSELK | Returns the modified Bessel function Kn(x). |
| BESSELY | Returns the Bessel function Yn(x). |
| BIN2DEC | Converts a binary number to decimal. |
| BIN2HEX | Converts a binary number to hexadecimal. |
| BIN2OCT | Converts a binary number to octal. |
| COMPLEX | Converts real and imaginary coefficients into a complex number. |
| CONVERT | Converts a number from one measurement system to another. |
| CUBEKPIMEMBER | Returns 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 | Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube. |
| CUBEMEMBERPROPERTY | Returns 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 | Returns 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 | Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel. |
| CUBESETCOUNT | Returns the number of items in a set. |
| CUBEVALUE | Returns an aggregated value from a cube. |
| DEC2BIN | Converts a decimal number to binary. |
| DEC2HEX | Converts a decimal number to hexadecimal. |
| DEC2OCT | Converts a decimal number to octal. |
| DELTA | Tests whether two values are equal. |
| ERF | Returns the error function. |
| ERFC | Returns the complementary error function. |
| GESTEP | Tests whether a number is greater than a threshold value. |
| HEX2BIN | Converts a hexadecimal number to binary. |
| HEX2DEC | Converts a hexadecimal number to decimal. |
| HEX2OCT | Converts a hexadecimal number to octal. |
| IMABS | Returns the absolute value (modulus) of a complex number. |
| IMAGINARY | Returns the imaginary coefficient of a complex number. |
| IMARGUMENT | Returns the argument theta, an angle expressed in radians. |
| IMCONJUGATE | Returns the complex conjugate of a complex number. |
| IMCOS | Returns the cosine of a complex number |
| IMDIV | Returns the quotient of two complex numbers. |
| IMEXP | Returns the exponential of a complex number. |
| IMLN | Returns the natural logarithm of a complex number. |
| IMLOG10 | Returns the base-10 logarithm of a complex number. |
| IMLOG2 | Returns the base-2 logarithm of a complex number. |
| IMPOWER | Returns a complex number raised to an integer power. |
| IMPRODUCT | Returns the product of from 2 to 29 complex numbers |
| IMREAL | Returns the real coefficient of a complex number |
| IMSIN | Returns the sine of a complex number |
| IMSQRT | Returns the square root of a complex number |
| IMSUB | Returns the difference between two complex numbers |
| IMSUM | Returns the sum of complex numbers. |
| OCT2BIN | Converts an octal number to binary. |
| OCT2DEC | Converts an octal number to decimal. |
| OCT2HEX | Converts an octal number to hexadecimal. |
| SUMIFS | Adds the cells in a range that meet multiple criteria |