Class | Description | |
---|---|---|

AbsFunctionInfo | Returns the absolute value of the specified value. | |

AccrIntFunctionInfo | Returns the accrued interest for a security that pays periodic interest. | |

AccrIntMFunctionInfo | Returns the accrued interest for a security that pays interest at maturity. | |

AcosFunctionInfo | Returns the angle whose cosine is the specified value. The angle is in radians between 0 (zero) and pi. | |

AcoshFunctionInfo | Returns the inverse hyperbolic cosine of the specified value. | |

AddOperatorInfo | Represents the addition operator. | |

AddressFunctionInfo | Creates a cell address as text, given specified row and column numbers. | |

AmordegrcFunctionInfo | Returns the depreciation for each accounting period. | |

AmorlincFunctionInfo | Returns the depreciation for each accounting period. | |

AndFunctionInfo | Returns true if all its arguments are true; otherwise, returns false if one or more arguments are false. | |

ArrayExpression | Represents an expression with an array of constant values as the expression. | |

ArrayExpressionFactory | Represents a means of creating ArrayExpression objects in environments that do not support parameterized constructors. | |

AsinFunctionInfo | Returns the angle whose sine is the specified value. | |

AsinhFunctionInfo | Returns the inverse hyperbolic sine of a number. | |

Atan2FunctionInfo | Returns the arctangent of the specified x- and y-coordinates. | |

AtanFunctionInfo | Returns the angle whose tangent is the specified value. | |

AtanhFunctionInfo | Returns the inverse hyperbolic tangent of a number. | |

AveDevFunctionInfo | Returns the average of the absolute deviations of the specified values from their mean. | |

AverageAFunctionInfo | Returns the average of the specified values. | |

AverageFunctionInfo | Returns the average of the specified values. | |

AverageIfFunctionInfo | ||

AverageIfsFunctionInfo | ||

BesselIFunctionInfo | Returns the Bessel function of the first kind evaluated for purely imaginary arguments. | |

BesselJFunctionInfo | Returns the Bessel function of the first kind. | |

BesselKFunctionInfo | Returns the modified Bessel function of the second kind evaluated for purely imaginary arguments. | |

BesselYFunctionInfo | Returns the Bessel function of the second kind. | |

BetaDistFunctionInfo | Returns the cumulative beta distribution function. | |

BetaInvFunctionInfo | Returns the inverse of the cumulative beta distribution function. | |

Bin2DecFunctionInfo | Converts a binary number to decimal. | |

Bin2HexFunctionInfo | Converts a binary number to hexadecimal. | |

Bin2OctFunctionInfo | Converts a binary number to octal. | |

BinaryOperatorExpression | Represents an expression with a binary operator applied to a pair of operands as the expression. | |

BinaryOperatorExpressionFactory | Represents a means of creating BinaryOperatorExpression objects in environments that do not support parameterized constructors. | |

BinaryOperatorInfo | Represents the abstract base class for defining binary operators. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated. | |

BinomDistFunctionInfo | Returns the individual term binomial distribution probability. | |

BooleanExpression | Represents an expression type with a boolean constant value as the expression. | |

BooleanExpressionFactory | Represents a means of creating BooleanExpression objects in environments that do not support parameterized constructors. | |

CalcArray | Represents an array of constants during the evaluation of a formula. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated. | |

CalcConvert | Represents the converting of a value to a specified data type. This is a %[LangWord]static class% and so cannot be inherited or instantiated. | |

CalcError | Represents calculation errors. | |

CalcErrorConverter | Converts CalcError objects to and from other data types. | |

CalcMissingArgument | Represents a missing argument during the evaluation of a formula. | |

CalcReference | Represents a cell or range reference during the evaluation of a formula. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated. | |

CeilingFunctionInfo | Rounds a number up to the nearest multiple of a specified value. | |

CellExpression | Represents an expression with a cell reference as the expression. | |

CellExpressionFactory | Represents a means of creating CellExpression objects in environments that do not support parameterized constructors. | |

CharFunctionInfo | Returns the character specified by a number. | |

ChiDistFunctionInfo | Returns the one-tailed probability of the chi-squared distribution. | |

ChiInvFunctionInfo | Returns the inverse of the one-tailed probability of the chi-squared distribution. | |

ChiTestFunctionInfo | Returns the test for independence from the chi-squared distribution. | |

ChooseFunctionInfo | Returns a value from a list of values. | |

CleanFunctionInfo | Removes all nonprintable characters from text. | |

CodeFunctionInfo | Returns a numeric code to represent the first character in a text string. | |

ColumnFunctionInfo | Returns the column number of a reference. | |

ColumnsFunctionInfo | Returns the number of columns in an array or reference. | |

CombinFunctionInfo | Returns the number of possible combinations for a specified number of items. | |

ComplexFunctionInfo | ||

ConcatenateFunctionInfo | Combines multiple text strings or numbers into one text string. | |

ConcatenateOperatorInfo | Represents the concatenation operator. | |

ConfidenceFunctionInfo | Returns the confidence interval for a population mean. | |

ConstantExpression | Represents the abstract class from which all constant value expression types derive. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated. | |

ConvertFunctionInfo | Returns an indication of whether a number is equal to a threshold. | |

CorrelFunctionInfo | Returns the correlation coefficient of the two sets of data. | |

CosFunctionInfo | Returns the cosine of the specified angle. | |

CoshFunctionInfo | Returns the hyperbolic cosine of the specified value. | |

CountAFunctionInfo | Counts the number of number values in the arguments. | |

CountBlankFunctionInfo | Returns the number of empty (or blank) cells in a range of cells on a sheet. | |

CountFunctionInfo | Counts the number of number values in the arguments. | |

CountIfFunctionInfo | Counts values based on criteria. | |

CountIfsFunctionInfo | ||

CoupDayBSFunctionInfo | Returns the number of days from the beginning of the coupon period to the settlement date. | |

CoupDaysFunctionInfo | Returns the number of days in the coupon period that contains the settlement date. | |

CoupDaysNCFunctionInfo | Returns the number of days from the settlement date to the next coupon date. | |

CoupNCDFunctionInfo | Returns a number that represents the next coupon date after the settlement date. | |

CoupNumFunctionInfo | Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon. | |

CoupPcdFunctionInfo | Returns a number that represents the previous coupon date before the settlement date. | |

CovarFunctionInfo | Returns the average of the products of deviations for each data point pair in two sets of numbers. | |

CritBinomFunctionInfo | Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. | |

CumIpmtFunctionInfo | Returns the cumulative interest paid on a loan between start_period and end_period. | |

CumPrincFunctionInfo | Returns the cumulative principal paid on a loan between start_period and end_period. | |

DateDifFunctionInfo | Returns the number of days, months, or years betwwen two dates. | |

DateFunctionInfo | Returns the DateTime object for a particular date, specified by the year, month, and day. | |

DateValueFunctionInfo | Returns the DateTime object of the specified date. | |

DAverageFunctionInfo | Returns the average of values in a column in a list that match the specified conditions. | |

DayFunctionInfo | Returns the day number of the month (integer 1 to 31) that corresponds to the specified date. | |

Days360FunctionInfo | Returns the number of days between two dates based on a 360-day year. | |

DbFunctionInfo | Returns the depreciation of an asset for a specified period using the fixed-declining balance method. | |

DCountAFunctionInfo | Counts the cells that are not empty in a column in a list that match the specified conditions. | |

DCountFunctionInfo | Counts the cells that contain numbers in a column in a list that match the specified conditions. | |

DdbFunctionInfo | Returns the depreciation of an asset for a specified period using the double-declining balance method or another method you specify. | |

Dec2BinFunctionInfo | Converts a decimal number to binary. | |

Dec2HexFunctionInfo | Converts a decimal number to hexadecimal. | |

Dec2OctFunctionInfo | Converts a decimal number to octal. | |

DegreesFunctionInfo | Converts the specified value from radians to degrees. | |

DeltaFunctionInfo | Identifies whether two values are equal. | |

DevSqFunctionInfo | Returns the sum of squares of deviations of data points from their sample mean. | |

DGetFunctionInfo | Extracts a single value from a column in a list that matches the specified conditions. | |

DiscFunctionInfo | Returns the discount rate for a security. | |

DivideOperatorInfo | Represents the division operator. | |

DMaxFunctionInfo | Returns the largest number in a column in a list that matches the specified conditions. | |

DMinFunctionInfo | Returns the smallest number in a column in a list that matches the specified conditions. | |

DollarDeFunctionInfo | Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number. | |

DollarFrFunctionInfo | Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number. | |

DollarFunctionInfo | Converts a number to text using currency format, with the decimals rounded to the specified place. | |

DoubleExpression | Represents an expression with a double constant value as the expression. | |

DoubleExpressionFactory | Represents a means of creating DoubleExpression objects in environments that do not support parameterized constructors. | |

DProductFunctionInfo | Multiplies the values in a column in a list that match the specified conditions. | |

DStDevFunctionInfo | Estimates the standard deviation of a population based on a sample, using the values in a column in a list that match the specified conditions. | |

DStDevPFunctionInfo | Calculates the standard deviation of a population based on the entire populcation, using the values in a column in a list that match the specified conditions. | |

DSumFunctionInfo | Adds the values in a column in a list that match the specified conditions. | |

DurationFunctionInfo | Returns the Macauley duration for an assumed par value of $100. | |

DVarFunctionInfo | Estimates the variance of a population based on a sample, using the values in a column in a list that match the specified conditions. | |

DVarPFunctionInfo | Calculates the variance of a population based on the entire population, using the values in a column in a list that match the specified conditions. | |

EDateFunctionInfo | Returns the DateTime object that is the indicated number of months before or after a specified date. | |

EffectFunctionInfo | Returns the effective annual interest rate for a given nominal annual interest rate and the number of compounding periods per year. | |

EoMonthFunctionInfo | Returns the DateTime object for the last day of the month (end of month) that is the indicated number of months before or after the start date. | |

EqualOperatorInfo | Represents the equals operator. | |

ErfcFunctionInfo | Returns the complementary error function integrated between a lower limit and infinity. | |

ErfFunctionInfo | Returns the error function integrated between a lower and an upper limit. | |

ErrorExpression | Represents an expression with an error constant value as the expression. | |

ErrorExpressionFactory | Represents a means of creating ErrorExpression objects in environments that do not support parameterized constructors. | |

ErrorTypeFunctionInfo | Returns a number corresponding to one of the error values. | |

EuroConvertFunctionInfo | Converts a currency value from one source to another. | |

EuroFunctionInfo | Returns one euro as a given national currency. | |

EvenFunctionInfo | Rounds the specified value up to the nearest even integer. | |

ExactFunctionInfo | Returns 1 (True) if two strings are the same; otherwise, 0 (False). | |

ExpFunctionInfo | Returns e raised to the power of the specified value. | |

ExponDistFunctionInfo | Returns the exponential distribution or the probability density. | |

ExponentOperatorInfo | Represents the exponent operator. | |

Expression | Represents the abstract class from which all expression types derive. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated. | |

ExternalCellExpression | Represents an expression with an external cell reference as the expression. | |

ExternalCellExpressionFactory | Represents a means of creating ExternalCellExpression objects in environments that do not support parameterized constructors. | |

ExternalNameExpression | Represents an expression with an external named variable as the expression. | |

ExternalRangeExpression | Represents an expression with an external range reference as the expression. | |

ExternalRangeExpressionFactory | Represents a means of creating ExternalRangeExpression objects in environments that do not support parameterized constructors. | |

ExternalReferenceExpression | Represents the abstract class from which all external reference expression types derive. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated. | |

FactDoubleFunctionInfo | Returns the double factorial of a number. | |

FactFunctionInfo | Returns the factorial of the specified number. | |

FalseFunctionInfo | Returns the value for logical false. | |

FDistFunctionInfo | Returns the F probability distribution, to see degrees of diversity between two sets of data. | |

FindFunctionInfo | Finds one text value within another. | |

FInvFunctionInfo | Returns the inverse of the F probability distribution. | |

FisherFunctionInfo | Returns the Fisher transformation for a specified value. | |

FisherInvFunctionInfo | Returns the inverse of the Fisher transformation. | |

FixedFunctionInfo | Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. | |

FloorFunctionInfo | Rounds a number down to the nearest multiple of a specified value. | |

ForecastFunctionInfo | Calculates a future value using existing values. | |

FpCategoryAttribute | Represents the FarPoint category attribute. | |

FrequencyFunctionInfo | Returns the number of possible permutations for a specified number of items. | |

FTestFunctionInfo | Represents the FTEST function. | |

FunctionExpression | Represents an expression with a function applied to a list of parameters as the expression. | |

FunctionExpressionFactory | Represents a means of creating FunctionExpression objects in environments that do not support parameterized constructors. | |

FunctionInfo | Represents an abstract base class for defining functions. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated. | |

FvFunctionInfo | Returns the future value of an investment based on a present value, periodic payments, and a specified interest rate. | |

FvScheduleFunctionInfo | Returns the future value of an initial principal after applying a series of compound interest rates. | |

GammaDistFunctionInfo | Returns the gamma distribution. | |

GammaInvFunctionInfo | Returns the inverse of the gamma cumulative distribution. | |

GammaLnFunctionInfo | Returns the natural logarithm of the Gamma function. | |

GcdFunctionInfo | Returns the greatest common divisor of two numbers. | |

GeoMeanFunctionInfo | Returns the geometric mean of a set of positive data. | |

GeStepFunctionInfo | Returns an indication of whether a number is equal to a threshold. | |

GreaterThanOperatorInfo | Represents the greater than operator. | |

GreaterThanOrEqualOperatorInfo | Represents the greater than or equal operator. | |

GrowthFunctionInfo | ||

HarMeanFunctionInfo | Returns the harmonic mean of a data set. | |

Hex2BinFunctionInfo | Converts a hexadecimal number to binary. | |

Hex2DecFunctionInfo | Converts a hexadecimal number to decimal. | |

Hex2OctFunctionInfo | Converts a hexadecimal number to octal. | |

HLookupFunctionInfo | Returns a value or the reference to a value from within an array or range. | |

HourFunctionInfo | Returns the hour that corresponds to the provided time. | |

HypGeomDistFunctionInfo | Returns the hypergeometric distribution. | |

IfErrorFunctionInfo | ||

IfFunctionInfo | Returns one of two provided values based on a logical value after performing a comparison. | |

ImAbsFunctionInfo | ||

ImaginaryFunctionInfo | ||

ImArgumentFunctionInfo | ||

ImConjugateFunctionInfo | ||

ImCosFunctionInfo | ||

ImDivFunctionInfo | ||

ImExpFunctionInfo | ||

ImLnFunctionInfo | ||

ImLog10FunctionInfo | ||

ImLog2FunctionInfo | ||

ImPowerFunctionInfo | ||

ImProductFunctionInfo | ||

ImRealFunctionInfo | ||

ImSinFunctionInfo | ||

ImSqrtFunctionInfo | ||

ImSubFunctionInfo | ||

ImSumFunctionInfo | ||

IndexFunctionInfo | Returns a value or the reference to a value from within an array or range. | |

InterceptFunctionInfo | Calculates the point at which a line intersects the y-axis by using existing x-values and y-values. | |

IntersectOperatorInfo | Represents the intersect operator. | |

IntFunctionInfo | Rounds a specified number down to the nearest integer. | |

IntRateFunctionInfo | Returns the interest rate for a fully invested security. | |

IpmtFunctionInfo | Returns the calculation of payment of interest on a loan. | |

IrrFunctionInfo | Returns the internal rate of return for a series of cash flows represented by the numbers in values. | |

IsBlankFunctionInfo | Tests whether a value, expression, or referenced cell is empty. | |

IsErrFunctionInfo | Tests whether a value, expression, or referenced cell has an error other than not available (#N/A). | |

IsErrorFunctionInfo | Tests whether a value, expression, or referenced cell has an error of any kind. | |

IsEvenFunctionInfo | Tests whether a value, expression, or referenced cell is even. | |

IsLogicalFunctionInfo | Tests whether a value, expression, or referenced cell is a logical value. | |

IsNAFunctionInfo | Tests whether a value, expression, or referenced cell has the not available (#N/A) error value. | |

IsNonTextFunctionInfo | Tests whether a value, expression, or referenced cell has non-text data. | |

IsNumberFunctionInfo | Tests whether a value, expression, or referenced cell has numeric data. | |

IsOddFunctionInfo | Tests whether a value, expression, or referenced cell is odd. | |

IspmtFunctionInfo | ||

IsRefFunctionInfo | Tests whether a value is a cell reference. | |

IsTextFunctionInfo | Tests whether a value, expression, or referenced cell has text data. | |

KurtFunctionInfo | Returns the kurtosis of a data set. | |

LargeFunctionInfo | Returns the nth largest value in a data set. | |

LcmFunctionInfo | Returns the least common multiple of integers. | |

LeftFunctionInfo | Returns the first (or leftmost) characters from a text value. | |

LenFunctionInfo | Returns the number of characters in a text string. | |

LessThanOperatorInfo | Represents the less than operator. | |

LessThanOrEqualOperatorInfo | Represents the less than or equal operator. | |

LinEstFunctionInfo | ||

LnFunctionInfo | Returns the natural logarithm of the specified number. | |

Log10FunctionInfo | Returns the logarithm base 10 of a number. | |

LogEstFunctionInfo | ||

LogFunctionInfo | Returns the logarithm base Y of a number X. | |

LogInvFunctionInfo | Returns the inverse of the lognormal cumulative distribution function of x. | |

LogNormDistFunctionInfo | Returns the cumulative natural log normal distribution of x. | |

LookupFunctionInfo | Returns a value or the reference to a value from within an array or range. | |

LowerFunctionInfo | Converts text to lowercase letters. | |

MatchFunctionInfo | ||

MaxAFunctionInfo | Returns the maximum value of all arguments. | |

MaxFunctionInfo | Returns the maximum value of all arguments. | |

MDetermFunctionInfo | ||

MDurationFunctionInfo | Returns the modified duration for a security with an assumed par value of $100. | |

MedianFunctionInfo | Returns the number in the middle of the provided set of numbers. | |

MidFunctionInfo | Returns the requested number of characters from a text string starting at the position you specify. | |

MinAFunctionInfo | Returns the minimum value of all arguments. | |

MinFunctionInfo | Returns the minimum value of all arguments. | |

MinuteFunctionInfo | Returns the minute corresponding to the provided time value. | |

MInverseFunctionInfo | ||

MIrrFunctionInfo | Returns the modified internal rate of return for a series of periodic cash flows. | |

MissingArgumentExpression | Represents an expression with a missing argument constant value as the expression. | |

MMultFunctionInfo | ||

ModeFunctionInfo | Returns the most frequently occurring value in a set of data. | |

ModFunctionInfo | Returns the remainder after the Number argument (dividend) is divided by the Divisor argument. | |

MonthFunctionInfo | Returns the month corresponding to the specified date value. | |

MRoundFunctionInfo | Returns a number rounded to the desired multiple. | |

MultinomialFunctionInfo | Calculates the ratio of the factorial of a sum of values to the product of factorials. | |

MultiplyOperatorInfo | Represents the multiplication operator. | |

MultiRangeExpression | Represents an expression with the two values as the reference expression. | |

NAFunctionInfo | Returns the error value #N/A that means 'not available'. | |

NameExpression | Represents an expression with a named variable as the expression. | |

NegateOperatorInfo | Represents the unary negation operator. | |

NegBinomDistFunctionInfo | Returns the negative binomial distribution. | |

NetWorkdaysFunctionInfo | Returns the number of whole working days between start date and end date. | |

NFunctionInfo | Returns a value converted to a number. | |

NominalFunctionInfo | Returns the nominal annual interest rate for a given effective rate and number of compounding periods per year. | |

NormDistFunctionInfo | Returns the normal cumulative distribution for the specified mean and standard deviation. | |

NormInvFunctionInfo | Returns the inverse of the normal cumulative distribution for the given mean and standard deviation. | |

NormSDistFunctionInfo | Returns the standard normal cumulative distribution function. | |

NormSInvFunctionInfo | Returns the inverse of the standard normal cumulative distribution. | |

NotEqualOperatorInfo | Represents the not-equal operator. | |

NotFunctionInfo | Reverses the logical value of its argument. | |

NowFunctionInfo | Returns the DateTime object of the current date and time. | |

NPerFunctionInfo | Returns the number of periods for an investment based on a present value, future value, periodic payments, and a specified interest rate. | |

NpvFunctionInfo | Calculates the net present value of an investment by using a discount rate and a series of future payments and income. | |

Oct2BinFunctionInfo | Converts a octal number to binary. | |

Oct2DecFunctionInfo | Converts a octal number to decimal. | |

Oct2HexFunctionInfo | Converts a octal number to hexadecimal. | |

OddFPriceFunctionInfo | Returns the price per $100 face value of a security having an odd (short or long) first period. | |

OddFunctionInfo | Rounds the specified value up to the nearest odd integer. | |

OddFYieldFunctionInfo | Returns the yield of a security that has an odd (short or long) first period. | |

OddLPriceFunctionInfo | Returns the price per $100 face value of a security having an odd (short or long) last coupon period. | |

OddLYieldFunctionInfo | Returns the yield of a security that has an odd (short or long) last period. | |

OffsetFunctionInfo | Returns a reference to a range that is the specified number of rows and columns from a the specified cell or range. | |

OperatorInfo | Represents the abstract base class for defining operators. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated. | |

OrFunctionInfo | Returns true if any argument is true; returns false if all arguments are false. | |

ParenthesesExpression | Represents an expression type for parentheses surrounding a specified expression. | |

ParenthesesExpressionFactory | Represents a means of creating ParenthesesExpression objects in environments that do not support parameterized constructors. | |

PearsonFunctionInfo | Returns the Pearson product moment correlation coefficient. | |

PercentileFunctionInfo | Returns the nth percentile of values in a range. | |

PercentOperatorInfo | Represents the percentage operator. | |

PercentRankFunctionInfo | Returns the rank of a value in a data set as a percentage of the data set. | |

PermutFunctionInfo | Returns the number of possible permutations for a specified number of items. | |

PiFunctionInfo | Provides pi as 3.1415926536. | |

PlusOperatorInfo | Represents the unary plus operator. | |

PmtFunctionInfo | Returns the payment amount for a loan given the present value, specified interest rate, and number of terms. | |

PoissonFunctionInfo | Returns the Poisson distribution. | |

PowerFunctionInfo | Raises the specified number to the given power. | |

PpmtFunctionInfo | Returns the amount of payment of principal. | |

PriceDiscFunctionInfo | Returns the price per $100 face value of a discounted security. | |

PriceFunctionInfo | Returns the price per $100 face value of a security that pays periodic interest. | |

PriceMatFunctionInfo | Returns the price at maturity per $100 face value of a security that pays interest. | |

ProbFunctionInfo | Returns the probability that values in a range are between two limits. | |

ProductFunctionInfo | Multiplies all the arguments and returns the product. | |

ProperFunctionInfo | Capitalizes the first letter in each word of a text string. | |

PvFunctionInfo | Returns the present value of an investment based on the interest rate, number and amount of periodic payments, and future value. | |

QuartileFunctionInfo | Returns the quartile (of which quarter or 25 percent) of a data set. | |

QuotientFunctionInfo | Returns the integer portion of a division. | |

RadiansFunctionInfo | Converts the specified number from degrees to radians. | |

RandBetweenFunctionInfo | Represents the RANDBETWEEN function. | |

RandFunctionInfo | Returns an evenly distributed random number greater than or equal to 0 and less than 1. | |

RangeExpression | Represents an expression with a range reference as the expression. | |

RangeExpressionFactory | Represents a means of creating RangeExpression objects in environments that do not support parameterized constructors. | |

RankFunctionInfo | Returns the rank of a number in a set of numbers. | |

RateFunctionInfo | Returns the interest rate per period of an annuity. | |

ReceivedFunctionInfo | Returns the amount received at maturity for a fully invested security. | |

ReferenceExpression | Represents the abstract class from which all reference expression types derive. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated. | |

ReplaceFunctionInfo | Replaces part of a text string with a different text string. | |

ReptFunctionInfo | Repeats text a specified number of times. | |

RightFunctionInfo | Returns the rightmost characters from a text value. | |

RomanFunctionInfo | ||

RoundDownFunctionInfo | Rounds the specified number down to the nearest number, using the specified number of decimal places. | |

RoundFunctionInfo | Rounds the specified value to the nearest number, using the specified number of decimal places. | |

RoundUpFunctionInfo | Rounds the specified number up to the nearest number, using the specified number of decimal places. | |

RowFunctionInfo | Returns the row number of a reference. | |

RowsFunctionInfo | Returns the number of rows in an array or reference. | |

RSqFunctionInfo | Represents the RSQ function. | |

SearchFunctionInfo | ||

SecondFunctionInfo | Returns the seconds (0 to 59) value for a specified time value. | |

SeriesSumFunctionInfo | Returns the sum of a power series. | |

SignFunctionInfo | Returns the sign of a number. | |

SinFunctionInfo | Returns the sine of the specified angle. | |

SinhFunctionInfo | Returns the hyperbolic sine of the specified number. | |

SkewFunctionInfo | Returns the skewness of a distribution. | |

SlnFunctionInfo | Returns the straight-line depreciation of an asset for one period. | |

SlopeFunctionInfo | Calculates the slope of a linear regression. | |

SmallFunctionInfo | Returns the nth smallest value in a data set. | |

SqrtFunctionInfo | Returns the positive square root of the specified number. | |

SqrtPiFunctionInfo | Represents the SQRTPI function. | |

StandardizeFunctionInfo | Returns a normalized value from a distribution characterized by mean and standard deviation. | |

StDevAFunctionInfo | Returns the standard deviation for a set of numbers. | |

StDevFunctionInfo | Returns the standard deviation for a set of numbers. | |

StDevPAFunctionInfo | Calculates standard deviation based on the entire population given as arguments. | |

StDevPFunctionInfo | Calculates standard deviation based on the entire population given as arguments. | |

StEyxFunctionInfo | Returns the standard error of the predicted y value for each x. | |

StringExpression | Represents an expression with a string constant value as the expression. | |

SubstituteFunctionInfo | Substitutes a new string for specified characters in an existing string. | |

SubtotalFunctionInfo | Returns a subtotal. | |

SubtractOperatorInfo | Represents the subtraction operator. | |

SumFunctionInfo | Sums values, cells, or blocks. | |

SumIfFunctionInfo | Sums values based on criteria. | |

SumIfsFunctionInfo | ||

SumProductFunctionInfo | Multiplies corresponding components in the given arrays, and returns the sum of those products. | |

SumSqFunctionInfo | Returns the sum of the squares of the arguments. | |

SumX2MY2FunctionInfo | Returns the sum of the difference of the squares of two arrays. | |

SumX2PY2FunctionInfo | Returns the sum of the sum of squares of corresponding values in two arrays. | |

SumXMY2FunctionInfo | Returns the sum of the difference of squares of corresponding values in two arrays. | |

SydFunctionInfo | Returns the sum-of-years' digits depreciation of an asset for a specified period. | |

TableReferenceExpression | Represents an expression with a table reference as the expression. | |

TanFunctionInfo | Returns the tangent of the specified angle. | |

TanhFunctionInfo | Returns the hyperbolic tangent of the specified number. | |

TBillEqFunctionInfo | Returns the equivalent yield for a Treasury bill (or T-bill). | |

TBillPriceFunctionInfo | Returns the price per $100 face value for a Treasury bill (or T-bill). | |

TBillYieldFunctionInfo | Returns the yield for a Treasury bill (or T-bill). | |

TDistFunctionInfo | Returns the probability for the t-distribution. | |

TextFunctionInfo | ||

TFunctionInfo | Returns the text referred to by value. | |

TimeFunctionInfo | Returns a TimeSpan object for the given hour, minute, and second. | |

TimeValueFunctionInfo | Returns a TimeSpan object represented by a text string. | |

TInvFunctionInfo | Returns the t-value of the t-distribution as a function of the probability and the degrees of freedom. | |

TodayFunctionInfo | Returns the DateTime object of the current date. | |

TransposeFunctionInfo | ||

TrendFunctionInfo | ||

TrimFunctionInfo | Removes extra spaces from a string and leaves single spaces between words. | |

TrimMeanFunctionInfo | Returns the mean of a subset of data excluding the topmost and bottommost data. | |

TrueFunctionInfo | Returns the value for logical true. | |

TruncFunctionInfo | Removes the specified fractional part of the specified number. | |

TTestFunctionInfo | Returns the probability associated with a t-test. | |

TypeFunctionInfo | Returns the type of value. | |

UnaryOperatorExpression | Represents an expression with a unary operator applied to a single operand as the expression. | |

UnaryOperatorExpressionFactory | Represents a means of creating UnaryOperatorExpression objects in environments that do not support parameterized constructors. | |

UnaryOperatorInfo | Represents the abstract base class for defining unary operators. This class is abstract (MustInherit in Visual Basic) and so cannot be instantiated. | |

UndefinedFunctionInfo | Represents an undefined function. | |

UnionOperatorInfo | Represents the union operator. | |

UpperFunctionInfo | Converts text to uppercase. | |

ValueFunctionInfo | Converts a string that represents a number to a number. | |

VarAFunctionInfo | Calculates variance based on a sample of a population. | |

VarFunctionInfo | Calculates variance based on a sample of a population. | |

VarPAFunctionInfo | Calculates variance based on the entire population. | |

VarPFunctionInfo | Calculates variance based on the entire population. | |

VdbFunctionInfo | Returns the depreciation of an asset for any period you specify using the variable declining balance method. | |

VLookupFunctionInfo | Returns a value or the reference to a value from within an array or range. | |

WeekdayFunctionInfo | Returns the number corresponding to the day of the week for a specified date. | |

WeekNumFunctionInfo | Returns a number that indicates the week of the year numerically. | |

WeibullFunctionInfo | Returns the two-parameter Weibull distribution. | |

WorkdayFunctionInfo | Returns a number that represents a date that is the indicated number of working days before or after start date. | |

XirrFunctionInfo | Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. | |

XnpvFunctionInfo | Returns the net present value for a schedule of cash flows that is not necessarily periodic. | |

YearFracFunctionInfo | Returns the year as an integer for a specified date. | |

YearFunctionInfo | Returns the year as an integer for a specified date. | |

YieldDiscFunctionInfo | Returns the annual yield for a discounted security. | |

YieldFunctionInfo | Returns the yield on a security that pays periodic interest. | |

YieldMatFunctionInfo | Returns the annual yield of a security that pays interest at maturity. | |

ZTestFunctionInfo | Returns the significance value of a z-test. |