# Excel2007Function Enumeration

Represents functions added in Excel 2007.

Syntax

'Declaration Public Enum Excel2007Function Inherits System.Enum

'Usage Dim instance As Excel2007Function

public enum Excel2007Function : System.Enum

Members

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

Inheritance Hierarchy

System.Object

System.ValueType

System.Enum

**Syncfusion.XlsIO.Excel2007Function**

AssemblyVersion

**Syncfusion.XlsIO.Base:** 16.4460.0.52

See Also