Skip to main content
A newer version of this page is available. .

XlFunc Members

Provides static methods used to construct an internal representation of an expression (an IXlFormulaParameter object).

Methods

Name Description
Average(IXlFormulaParameter[]) static An AVERAGE statistical function.
Column() static A COLUMN reference function
Column(XlCellRange) static A COLUMN reference function.
Concatenate(IXlFormulaParameter[]) static A CONCATENATE text function.
Count(IXlFormulaParameter[]) static A COUNT statistical function.
CountA(IXlFormulaParameter[]) static A COUNTA statistical function.
CountBlank(XlCellRange) static A COUNTBLANK statistical function.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetType() Gets the Type of the current instance. Inherited from Object.
If(IXlFormulaParameter, IXlFormulaParameter, IXlFormulaParameter) static An IF logical function.
Max(IXlFormulaParameter[]) static A MAX statistical function.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
Min(IXlFormulaParameter[]) static A MIN statistical function.
Param(XlVariantValue) static Creates a new IXlFormulaParameter object from the specified value.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
Row() static A ROW reference function
Row(XlCellRange) static A ROW reference function
Subtotal(XlCellRange, XlSummary, Boolean) static A SUBTOTAL mathematical function.
Subtotal(IList<XlCellRange>, XlSummary, Boolean) static A SUBTOTAL mathematical function.
Sum(IXlFormulaParameter[]) static A SUM mathematical function.
Text(IXlFormulaParameter, XlNumberFormat) static A TEXT text function.
Text(IXlFormulaParameter, String, Boolean) static A TEXT text function.
Text(XlVariantValue, XlNumberFormat) static A TEXT text function.
Text(XlVariantValue, String, Boolean) static A TEXT text function.
ToString() Returns a string that represents the current object. Inherited from Object.
Trunc(IXlFormulaParameter, Int32) static A TRUNC mathematical function.
Trunc(IXlFormulaParameter) static A TRUNC mathematical function.
VLookup(IXlFormulaParameter, XlCellRange, Int32, Boolean) static A VLOOKUP reference function
VLookup(XlVariantValue, XlCellRange, Int32, Boolean) static A VLOOKUP reference function.
See Also