Class Excel2007Function

Represents functions added in Excel 2007.

Inheritance
System.Object
Excel2007Function
Namespace: Syncfusion.XlsIO
Assembly: Syncfusion.XlsIO.UWP.dll
Syntax
public sealed class Excel2007Function : Enum

Fields

AVERAGEIF

Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria

Declaration
public const Excel2007Function AVERAGEIF
Field Value
Type
Excel2007Function

AVERAGEIFS

Returns the average (arithmetic mean) of all cells that meet multiple criteria.

Declaration
public const Excel2007Function AVERAGEIFS
Field Value
Type
Excel2007Function

BESSELI

Returns the modified Bessel function In(x).

Declaration
public const Excel2007Function BESSELI
Field Value
Type
Excel2007Function

BESSELJ

Returns the Bessel function Jn(x).

Declaration
public const Excel2007Function BESSELJ
Field Value
Type
Excel2007Function

BESSELK

Returns the modified Bessel function Kn(x).

Declaration
public const Excel2007Function BESSELK
Field Value
Type
Excel2007Function

BESSELY

Returns the Bessel function Yn(x).

Declaration
public const Excel2007Function BESSELY
Field Value
Type
Excel2007Function

BIN2DEC

Converts a binary number to decimal.

Declaration
public const Excel2007Function BIN2DEC
Field Value
Type
Excel2007Function

BIN2HEX

Converts a binary number to hexadecimal.

Declaration
public const Excel2007Function BIN2HEX
Field Value
Type
Excel2007Function

BIN2OCT

Converts a binary number to octal.

Declaration
public const Excel2007Function BIN2OCT
Field Value
Type
Excel2007Function

COMPLEX

Converts real and imaginary coefficients into a complex number.

Declaration
public const Excel2007Function COMPLEX
Field Value
Type
Excel2007Function

CONVERT

Converts a number from one measurement system to another.

Declaration
public const Excel2007Function CONVERT
Field Value
Type
Excel2007Function

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.

Declaration
public const Excel2007Function CUBEKPIMEMBER
Field Value
Type
Excel2007Function

CUBEMEMBER

Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube.

Declaration
public const Excel2007Function CUBEMEMBER
Field Value
Type
Excel2007Function

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.

Declaration
public const Excel2007Function CUBEMEMBERPROPERTY
Field Value
Type
Excel2007Function

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.

Declaration
public const Excel2007Function CUBERANKEDMEMBER
Field Value
Type
Excel2007Function

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.

Declaration
public const Excel2007Function CUBESET
Field Value
Type
Excel2007Function

CUBESETCOUNT

Returns the number of items in a set.

Declaration
public const Excel2007Function CUBESETCOUNT
Field Value
Type
Excel2007Function

CUBEVALUE

Returns an aggregated value from a cube.

Declaration
public const Excel2007Function CUBEVALUE
Field Value
Type
Excel2007Function

DEC2BIN

Converts a decimal number to binary.

Declaration
public const Excel2007Function DEC2BIN
Field Value
Type
Excel2007Function

DEC2HEX

Converts a decimal number to hexadecimal.

Declaration
public const Excel2007Function DEC2HEX
Field Value
Type
Excel2007Function

DEC2OCT

Converts a decimal number to octal.

Declaration
public const Excel2007Function DEC2OCT
Field Value
Type
Excel2007Function

DELTA

Tests whether two values are equal.

Declaration
public const Excel2007Function DELTA
Field Value
Type
Excel2007Function

ERF

Returns the error function.

Declaration
public const Excel2007Function ERF
Field Value
Type
Excel2007Function

ERFC

Returns the complementary error function.

Declaration
public const Excel2007Function ERFC
Field Value
Type
Excel2007Function

GESTEP

Tests whether a number is greater than a threshold value.

Declaration
public const Excel2007Function GESTEP
Field Value
Type
Excel2007Function

HEX2BIN

Converts a hexadecimal number to binary.

Declaration
public const Excel2007Function HEX2BIN
Field Value
Type
Excel2007Function

HEX2DEC

Converts a hexadecimal number to decimal.

Declaration
public const Excel2007Function HEX2DEC
Field Value
Type
Excel2007Function

HEX2OCT

Converts a hexadecimal number to octal.

Declaration
public const Excel2007Function HEX2OCT
Field Value
Type
Excel2007Function

IMABS

Returns the absolute value (modulus) of a complex number.

Declaration
public const Excel2007Function IMABS
Field Value
Type
Excel2007Function

IMAGINARY

Returns the imaginary coefficient of a complex number.

Declaration
public const Excel2007Function IMAGINARY
Field Value
Type
Excel2007Function

IMARGUMENT

Returns the argument theta, an angle expressed in radians.

Declaration
public const Excel2007Function IMARGUMENT
Field Value
Type
Excel2007Function

IMCONJUGATE

Returns the complex conjugate of a complex number.

Declaration
public const Excel2007Function IMCONJUGATE
Field Value
Type
Excel2007Function

IMCOS

Returns the cosine of a complex number

Declaration
public const Excel2007Function IMCOS
Field Value
Type
Excel2007Function

IMDIV

Returns the quotient of two complex numbers.

Declaration
public const Excel2007Function IMDIV
Field Value
Type
Excel2007Function

IMEXP

Returns the exponential of a complex number.

Declaration
public const Excel2007Function IMEXP
Field Value
Type
Excel2007Function

IMLN

Returns the natural logarithm of a complex number.

Declaration
public const Excel2007Function IMLN
Field Value
Type
Excel2007Function

IMLOG10

Returns the base-10 logarithm of a complex number.

Declaration
public const Excel2007Function IMLOG10
Field Value
Type
Excel2007Function

IMLOG2

Returns the base-2 logarithm of a complex number.

Declaration
public const Excel2007Function IMLOG2
Field Value
Type
Excel2007Function

IMPOWER

Returns a complex number raised to an integer power.

Declaration
public const Excel2007Function IMPOWER
Field Value
Type
Excel2007Function

IMPRODUCT

Returns the product of from 2 to 29 complex numbers

Declaration
public const Excel2007Function IMPRODUCT
Field Value
Type
Excel2007Function

IMREAL

Returns the real coefficient of a complex number

Declaration
public const Excel2007Function IMREAL
Field Value
Type
Excel2007Function

IMSIN

Returns the sine of a complex number

Declaration
public const Excel2007Function IMSIN
Field Value
Type
Excel2007Function

IMSQRT

Returns the square root of a complex number

Declaration
public const Excel2007Function IMSQRT
Field Value
Type
Excel2007Function

IMSUB

Returns the difference between two complex numbers

Declaration
public const Excel2007Function IMSUB
Field Value
Type
Excel2007Function

IMSUM

Returns the sum of complex numbers.

Declaration
public const Excel2007Function IMSUM
Field Value
Type
Excel2007Function

OCT2BIN

Converts an octal number to binary.

Declaration
public const Excel2007Function OCT2BIN
Field Value
Type
Excel2007Function

OCT2DEC

Converts an octal number to decimal.

Declaration
public const Excel2007Function OCT2DEC
Field Value
Type
Excel2007Function

OCT2HEX

Converts an octal number to hexadecimal.

Declaration
public const Excel2007Function OCT2HEX
Field Value
Type
Excel2007Function

SUMIFS

Adds the cells in a range that meet multiple criteria

Declaration
public const Excel2007Function SUMIFS
Field Value
Type
Excel2007Function

Extension Methods