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