Spread Silverlight Documentation
GrapeCity.CalcEngine.Functions Namespace
Inheritance Hierarchy
Provides the base classes and structures for the functionality for functions.
Classes
 ClassDescription
ClassCalcAbsFunction Returns the absolute value of a number. The absolute value of a number is the number without its sign.
ClassCalcAccrintFunction Returns the System.Double accrued interest for a security that pays periodic interest.
ClassCalcAccrintMFunction Returns the System.Double accrued interest for a security that pays interest at maturity.
ClassCalcAcosFunction Returns the arccosine, or inverse cosine, of a number.
ClassCalcAcoshFunction Returns the inverse hyperbolic cosine of a number.
ClassCalcAddressFunction Creates a cell address as text, given specified row and column numbers.
ClassCalcAmordegrcFunction Returns the System.Double depreciation for each accounting period.
ClassCalcAmorlincFunction Returns the System.Double depreciation for each accounting period.
ClassCalcAndFunction Returns true if all its arguments are true; returns false if one or more argument is false.
ClassCalcAsinFunction Returns the arcsine, or inverse sine, of a number.
ClassCalcAsinhFunction Returns the inverse hyperbolic sine of a number.
ClassCalcAtan2Function Returns the arctangent, or inverse tangent, of the specified x- and y-coordinates.
ClassCalcAtanFunction Returns the arctangent, or inverse tangent, of a number.
ClassCalcAtanhFunction Returns the inverse hyperbolic tangent of a number.
ClassCalcAveDevFunction Returns the average of the absolute deviations of data points from their mean.
ClassCalcAverageAFunction Calculates the average (arithmetic mean) of the values in the list of arguments.
ClassCalcAverageFunction Returns the average (arithmetic mean) of the arguments.
ClassCalcAverageIfFunction Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
ClassCalcAverageIfsFunction Returns the average (arithmetic mean) of all cells that meet multiple criteria.
ClassCalcBesselIFunction Returns the System.Double modified Bessel function, which is equivalent to the Bessel function evaluated for purely imaginary arguments.
ClassCalcBesselJFunction Returns the System.Double modified Bessel function represented by J(x).
ClassCalcBesselKFunction Returns the System.Double modified Bessel function represented by K(x).
ClassCalcBesselYFunction Returns the System.Double Bessel function, which is also called the Weber function or the Neumann function.
ClassCalcBetaDistFunction Returns the System.Double cumulative beta probability density function.
ClassCalcBetaInvFunction Returns the System.Double inverse of the cumulative beta probability density function for a specified beta distribution.
ClassCalcBin2DecFunction Returns the System.Int32 converted from binary to decimal.
ClassCalcBin2HexFunction Returns the System.String converted from binary to hexadecimal.
ClassCalcBin2OctFunction Returns the System.String converted from binary to octal.
ClassCalcBinomDistFunction Returns the System.Double individual term binomial distribution probability.
ClassCalcBuiltinFunction Represents an abstract base class for CalcEngine builtin functions.
ClassCalcCeilingFunction Returns number rounded up, away from zero, to the nearest multiple of significance.
ClassCalcCharFunction Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters.
ClassCalcChiDistFunction Returns the System.Double one tailed probability of the chi-squared distribution.
ClassCalcChiInvFunction Returns the System.Double inverse of the one-tailed probability of the chi-squared distribution.
ClassCalcChiTestFunction Returns the System.Double value from the chi-squared distribution.
ClassCalcChooseFunction Uses index_num to return a value from the list of value arguments.
ClassCalcCleanFunction Removes all nonprintable characters from text. Use CLEAN on text imported from other applications that contains characters that may not print with your operating system. For example, you can use CLEAN to remove some low-level computer code that is frequently at the beginning and end of data files and cannot be printed.
ClassCalcCodeFunction Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.
ClassCalcColumnFunction Returns the column number of the given reference.
ClassCalcColumnsFunction Returns the number of columns in an array or reference.
ClassCalcCombinFunction Returns the number of combinations for a given number of items.
ClassCalcComplexFunction Returns the System.String complex number given the real and imaginary coefficient.
ClassCalcConcatenateFunction Joins two or more text strings into one text string.
ClassCalcConfidenceFunction Returns the System.Double confidence interval for a population mean.
ClassCalcConvertFunction Returns the System.Double equivalent number when converted to another measurement system.
ClassCalcCorrelFunction Returns the System.Double correlation coefficient of the array1 and array2 cell ranges.
ClassCalcCosFunction Returns the cosine of the given angle.
ClassCalcCoshFunction Returns the hyperbolic cosine of a number.
ClassCalcCountAFunction Counts the number of cells that are not empty and the values within the list of arguments.
ClassCalcCountBlankFunction Counts empty cells in a specified range of cells.
ClassCalcCountFunction Counts the number of cells that contain numbers and counts numbers within the list of arguments.
ClassCalcCountIfFunction Counts the number of cells within a range that meet the given criteria.
ClassCalcCountIfsFunction Counts the number of cells within a range that meet multiple criteria.
ClassCalcCoupDayBsFunction Returns the System.Double number of days from the beginning of the coupon period to the settlement date.
ClassCalcCoupDaysFunction Returns the System.Double number of days in the coupon period that contains the settlement date.
ClassCalcCoupDaysNcFunction Returns the System.Double number of days from the settlement date to the next coupon date.
ClassCalcCoupNcdFunction Returns a System.Double number that represents the next coupon date after the settlement date.
ClassCalcCoupNumFunction Returns the System.Double number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
ClassCalcCoupPcdFunction Returns a System.Double number that represents the previous coupon date before the settlement date.
ClassCalcCovarFunction Returns the System.Double covariance of two lists of numbers.
ClassCalcCritBinomFunction Returns the System.Double smallest number which is the cumulative binomial distribution that is greater than a criterion value.
ClassCalcCumIpmtFunction Returns the System.Double cumulative interest paid on a loan between start_period and end_period.
ClassCalcCumPrincFunction Returns the System.Double cumulative principal paid on a loan between start_period and end_period.
ClassCalcDateDifFunction Returns the number of days, months, or years between two dates.
ClassCalcDateFunction Returns the System.DateTime that represents a particular date.
ClassCalcDateValueFunction Returns the System.DateTime of the date represented by date_text.
ClassCalcDAverageFunction Averages the values in a field (column) of records in a list or database that match conditions you specify.
ClassCalcDayFunction Returns the day of a date, represented by a serial number. The day is given as an System.Int32 ranging from 1 to 31.
ClassCalcDays360Function Returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to help compute payments if your accounting system is based on twelve 30-day months.
ClassCalcDbFunction Returns the System.Double depreciation of an asset for a specified period using the fixed-declining balance method.
ClassCalcDCountAFunction Counts the cells that contain numbers in a field (column) of records in a list or database that match conditions that you specify.
ClassCalcDCountFunction Counts the cells that contain numbers in a field (column) of records in a list or database that match conditions that you specify.
ClassCalcDdbFunction Returns the System.Double depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.
ClassCalcDec2BinFunction Returns the System.String converted from decimal to binary.
ClassCalcDec2HexFunction Returns the System.String converted from decimal to hexadecimal.
ClassCalcDec2OctFunction Returns the System.String converted from decimal to octal.
ClassCalcDegreesFunction Converts radians into degrees.
ClassCalcDeltaFunction Returns the System.Int32 value indicating if two numbers are equal.
ClassCalcDevSqFunction Returns the System.Double sum of squares of deviations of data points from their mean.
ClassCalcDGetFunction Extracts a single value from a column of a list or database that matches conditions that you specify.
ClassCalcDiscFunction Returns the System.Double discount rate for a security.
ClassCalcDMaxFunction Returns the largest number in a field (column) of records in a list or database that matches conditions you that specify.
ClassCalcDMinFunction Returns the smallest number in a field (column) of records in a list or database that matches conditions that you specify.
ClassCalcDollarDeFunction Returns the System.Double dollar fraction expressed as a decimal.
ClassCalcDollarFrFunction Returns the System.Double dollar decimal expressed as a fraction.
ClassCalcDollarFunction The function described in this Help topic converts a number to text format and applies a currency symbol. The name of the function (and the symbol that it applies) depends upon your language settings. This function converts a number to text using currency format, with the decimals rounded to the specified place. The format used is $#,##0.00_);($#,##0.00).
ClassCalcDProductFunction Multiplies the values in a field (column) of records in a list or database that match conditions that you specify.
ClassCalcDStDevFunction Estimates the standard deviation of a population based on a sample by using the numbers in a field (column) of records in a list or database that match conditions that you specify.
ClassCalcDStDevPFunction Calculates the standard deviation of a population based on the entire population by using the numbers in a field (column) of records in a list or database that match conditions that you specify.
ClassCalcDSumFunction Adds the numbers in a field (column) of records in a list or database that match conditions that you specify.
ClassCalcDurationFunction Returns the System.Double Macauley duration for an assumed par value of $100.
ClassCalcDVarFunction Estimates the variance of a population based on a sample by using the numbers in a field (column) of records in a list or database that match conditions that you specify.
ClassCalcDVarPFunction Calculates the variance of a population based on the entire population by using the numbers in a field (column) of records in a list or database that match conditions that you specify.
ClassCalcEDateFunction Returns the System.DateTime that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.
ClassCalcEffectFunction Returns the System.Double effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.
ClassCalcEoMonthFunction Returns the System.DateTime for the last day of the month that is the indicated number of months before or after start_date. Use EOMONTH to calculate maturity dates or due dates that fall on the last day of the month.
ClassCalcErfcFunction Returns the System.Double complementary error function integrated between x and infinity.
ClassCalcErfFunction Returns the System.Double error function integrated between lower_limit and upper_limit.
ClassCalcError_TypeFunction Returns a number corresponding to one of the error values or returns the #N/A error if no error exists.
ClassCalcEuroConvertFunction Converts a currency value from one source to another.
ClassCalcEuroFunction Returns one euro as a given national currency.
ClassCalcEvenFunction Returns number rounded up to the nearest even integer.
ClassCalcExactFunction Compares two text strings and returns true if they are exactly the same, false otherwise.
ClassCalcExpFunction Returns e raised to the power of number.
ClassCalcExponDistFunction Returns the System.Double exponential distribution.
ClassCalcFactDoubleFunction Returns the double factorial of a number.
ClassCalcFactFunction Returns the factorial of a number.
ClassCalcFalseFunction Returns the logical value false.
ClassCalcFDistFunction Returns the System.Double F probability distribution.
ClassCalcFindFunction Locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string.
ClassCalcFInvFunction Returns the System.Double inverse of the F probability distribution.
ClassCalcFisherFunction Returns the System.Double Fisher transformation at x.
ClassCalcFisherInvFunction Returns the System.Double inverse of the Fisher transformation.
ClassCalcFixedFunction 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 System.String.
ClassCalcFloorFunction Rounds number down, toward zero, to the nearest multiple of significance.
ClassCalcForecastFunction Returns the System.Double future value along a linear trend by using existing values.
ClassCalcFrequencyFunction Calculates how often values occur within a range of values, and then returns a vertical array of numbers.
ClassCalcFTestFunction Returns the System.Double result of an F-test.
ClassCalcFunction Represents an abstract base class for defining functions.
ClassCalcFvFunction Returns the System.Double future value of an investment based on periodic, constant payments and a constant interest rate.
ClassCalcFvScheduleFunction Returns the System.Double future value of an initial principal after applying compound interest rates.
ClassCalcGammaDistFunction Returns the System.Double gamma distribution.
ClassCalcGammaInvFunction Returns the System.Double inverse of the gamma cumulative distribution.
ClassCalcGammaLnFunction Returns the System.Double natural logarithm of the gamma function, ¦£(x).
ClassCalcGcdFunction Returns the greatest common divisor of two or more integers. The greatest common divisor is the largest integer that divides both number1 and number2 without a remainder.
ClassCalcGeoMeanFunction Returns the geometric mean of an array or range of positive data.
ClassCalcGeStepFunction Returns the boolean value depending if a number is greater than a threshold value.
ClassCalcGrowthFunction Returns the GrapeCity.CalcEngine.CalcArray predicted exponential growth by using existing data.
ClassCalcHarMeanFunction Returns the harmonic mean of a data set. The harmonic mean is the reciprocal of the arithmetic mean of reciprocals.
ClassCalcHex2BinFunction Returns the System.String converted from hexadecimal to binary.
ClassCalcHex2DecFunction Returns the System.Double number converted from hexadecimal to decimal.
ClassCalcHex2OctFunction Returns the System.String number converted from hexadecimal to octal.
ClassCalcHLookupFunction Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array.
ClassCalcHourFunction Returns the hour of a time value. The hour is given as an System.Int32, ranging from 0 (12:00 A.M.) to 23 (11:00 P.M.).
ClassCalcHypGeomDistFunction Returns the System.Double hyper geometric distribution for a finite population.
ClassCalcIfErrorFunction Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. Use the IFERROR function to trap and handle errors in a formula (formula: A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A formula always begins with an equal sign (=).).
ClassCalcIfFunction Returns one value if a condition you specify evaluates to true and another value if it evaluates to false.
ClassCalcImAbsFunction Returns the System.Double absolute value (modulus) of a complex number in x + yi or x + yj text format.
ClassCalcImaginaryFunction Returns the System.Double imaginary coefficient of a complex number in x + yi or x + yj text format.
ClassCalcImArgumentFunction Returns the System.Double argument (theta), an angle expressed in radians.
ClassCalcImConjugateFunction Returns the System.String complex conjugate of a complex number in x + yi or x + yj text format.
ClassCalcImCosFunction Returns the System.String cosine of a complex number in x + yi or x + yj text format.
ClassCalcImDivFunction Returns the System.String quotient of two complex numbers in x + yi or x + yj text format.
ClassCalcImExpFunction Returns the System.String exponential of a complex number in x + yi or x + yj text format.
ClassCalcImLnFunction Returns the System.String natural logarithm of a complex number in x + yi or x + yj text format.
ClassCalcImLog10Function Returns the System.String common logarithm (base 10) of a complex number in x + yi or x + yj text format.
ClassCalcImLog2Function Returns the System.String base-2 logarithm of a complex number in x + yi or x + yj text format.
ClassCalcImPowerFunction Returns a System.String complex number in x + yi or x + yj text format raised to a power.
ClassCalcImProductFunction Returns the System.String product of 1 to 255 complex numbers in x + yi or x + yj text format.
ClassCalcImRealFunction Returns the System.Double real coefficient of a complex number in x + yi or x + yj text format.
ClassCalcImSinFunction Returns the System.String sine of a complex number in x + yi or x + yj text format.
ClassCalcImSqrtFunction Returns the System.String square root of a complex number in x + yi or x + yj text format.
ClassCalcImSubFunction Returns the System.String difference of two complex numbers in x + yi or x + yj text format.
ClassCalcImSumFunction Returns the System.String sum of two or more complex numbers in x + yi or x + yj text format.
ClassCalcIndexFunction Returns a value or the reference to a value from within a table or range.
ClassCalcInterceptFunction Returns the System.Double intersection with the y-axis using a linear regression plotted through known values.
ClassCalcIntFunction Rounds a number down to the nearest integer.
ClassCalcIntrateFunction Returns the System.Double interest rate for a fully invested security.
ClassCalcIpmtFunction Returns the System.Double interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
ClassCalcIrrFunction Returns the System.Double internal rate of return for a series of cash flows represented by the numbers in values.
ClassCalcIsBlankFunction Checks whether the value is refers to an empty cell.
ClassCalcIsErrFunction Checks whether the value is refers to any error value except #N/A.
ClassCalcIsErrorFunction Checks whether the value is refers to any error value except #N/A.
ClassCalcIsEvenFunction Checks whether the number is even.
ClassCalcIsLogicalFunction Checks whether the value is refers to a logical value.
ClassCalcIsNAFunction Checks whether the value is refers to the #N/A (value not available) error value.
ClassCalcIsNonTextFunction Checks whether the value is refers to any item that is not text.
ClassCalcIsNumberFunction Checks whether the value is refers to a number.
ClassCalcIsOddFunction Checks whether the number is odd.
ClassCalcIspmtFunction Returns the System.Double interest paid during a specific period of an investment.
ClassCalcIsRefFunction Checks whether the value is refers to a reference.
ClassCalcIsTextFunction Checks whether the value is refers to text.
ClassCalcKurtFunction Returns the kurtosis of a data set.
ClassCalcLargeFunction Returns the k-th largest value in a data set.
ClassCalcLcmFunction Returns the least common multiple of integers. The least common multiple is the smallest positive integer that is a multiple of all integer arguments number1, number2, and so on. Use LCM to add fractions with different denominators.
ClassCalcLeftFunction Returns the first character or characters in a text string, based on the number of characters you specify.
ClassCalcLenFunction Returns the number of characters in a text string.
ClassCalcLinestFunction Returns the GrapeCity.CalcEngine.CalcArray coordinates for a straight line that best fits your data.
ClassCalcLnFunction Returns the natural logarithm of a number.
ClassCalcLog10Function Returns the base-10 logarithm of a number.
ClassCalcLogestFunction Returns the GrapeCity.CalcEngine.CalcArray array of values for an exponential curve that best fits your data.
ClassCalcLogFunction Returns the logarithm of a number to the base you specify.
ClassCalcLogInvFunction Returns the System.Double inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev
ClassCalcLogNormDistFunction Returns the System.Double cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev.
ClassCalcLookupFunction Returns a value either from a one-row or one-column range or from an array.
ClassCalcLowerFunction Converts all uppercase letters in a text string to lowercase.
ClassCalcMatchFunction Returns the relative position of an item in an array that matches a specified value in a specified order.
ClassCalcMaxAFunction Returns the largest value in a list of arguments.
ClassCalcMaxFunction Returns the largest value in a set of values.
ClassCalcMDetermFunction Returns the matrix determinant of an array.
ClassCalcMDurationFunction Returns the System.Double modified Macauley duration for a security with an assumed par value of $100.
ClassCalcMedianFunction Returns the median of the given numbers. The median is the number in the middle of a set of numbers.
ClassCalcMidFunction Returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
ClassCalcMinAFunction Returns the smallest value in the list of arguments.
ClassCalcMinFunction Returns the smallest number in a set of values.
ClassCalcMinuteFunction Returns the minutes of a time value. The minute is given as an System.Int32, ranging from 0 to 59.
ClassCalcMInverseFunction Returns the inverse matrix for the matrix stored in an array.
ClassCalcMIrrFunction Returns the System.Double modified internal rate of return for a series of periodic cash flows.
ClassCalcMMultFunction Returns the matrix product of two arrays.
ClassCalcModeFunction Returns the most frequently occurring, or repetitive, value in an array or range of data.
ClassCalcModFunction Returns the remainder after number is divided by divisor. The result has the same sign as divisor.
ClassCalcMonthFunction Returns the month of a date represented by a serial number. The month is given as an System.Int32, ranging from 1 (January) to 12 (December).
ClassCalcMRoundFunction Returns a number rounded to the desired multiple.
ClassCalcMultinomialFunction Returns the ratio of the factorial of a sum of values to the product of factorials.
ClassCalcNAFunction Returns the error value #N/A.
ClassCalcNegBinomDistFunction Returns the System.Double negative binomial distribution.
ClassCalcNetWorkdaysFunction Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. Use NETWORKDAYS to calculate employee benefits that accrue based on the number of days worked during a specific term.
ClassCalcNFunction Returns a value converted to a number.
ClassCalcNominalFunction Returns the System.Double nominal annual interest rate, given the effective rate and the number of compounding periods per year.
ClassCalcNormDistFunction Returns the System.Double normal cumulative distribution.
ClassCalcNormInvFunction Returns the System.Double inverse of the normal cumulative distribution.
ClassCalcNormSDistFunction Returns the System.Double standard normal cumulative distribution.
ClassCalcNormSInvFunction Returns the System.Double inverse of the standard normal cumulative distribution.
ClassCalcNotFunction Reverses the value of its argument. Use NOT when you want to make sure a value is not equal to one particular value.
ClassCalcNowFunction Returns the System.DateTime of the current date and time.
ClassCalcNperFunction Returns the System.Double number of periods for an investment based on periodic, constant payments and a constant interest rate.
ClassCalcNpvFunction Returns the System.Double net present value of a series of cash flows (in and out).
ClassCalcOct2BinFunction Returns the System.String number converted from octal to binary.
ClassCalcOct2DecFunction Returns the System.Double number converted from octal to decimal.
ClassCalcOct2HexFunction Returns the System.String number converted from octal to hexadecimal.
ClassCalcOddFPriceFunction Returns the System.Double price per $100 face value of a security having an odd (short or long) first period.
ClassCalcOddFunction Returns number rounded up to the nearest odd integer.
ClassCalcOddFYieldFunction Returns the System.Double yield of a security that has an odd (short or long) first period.
ClassCalcOddLPriceFunction Returns the System.Double price per $100 face value of a security having an odd (short or long) last coupon period.
ClassCalcOddLYieldFunction Returns the System.Double yield of a security that has an odd (short or long) last period.
ClassCalcOffsetFunction Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.
ClassCalcOrFunction Returns true if any argument is true; returns false if all arguments are false.
ClassCalcPearsonFunction Returns the System.Double Pearson product moment correlation coefficient.
ClassCalcPercentileFunction Returns the k-th percentile of values in a range.
ClassCalcPercentRankFunction Returns the rank of a value in a data set as a percentage of the data set.
ClassCalcPermutFunction Returns the System.Double number of permutations from a given number.
ClassCalcPiFunction Returns the mathematical constant pi.
ClassCalcPmtFunction Returns the System.Double payment for a loan with constant payments and fixed interest.
ClassCalcPoissonFunction Returns the Poisson distribution.
ClassCalcPowerFunction Returns the result of a number raised to a power.
ClassCalcPpmtFunction Returns the System.Double payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.
ClassCalcPriceDiscFunction Returns the System.Double price per $100 face value of a discounted security.
ClassCalcPriceFunction Returns the System.Double price per $100 face value of a security that pays periodic interest.
ClassCalcPriceMatFunction Returns the System.Double price per $100 face value of a security that pays interest at maturity.
ClassCalcProbFunction Returns the probability that values in a range are between two limits.
ClassCalcProductFunction Multiplies all the numbers given as arguments and returns the product.
ClassCalcProperFunction Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.
ClassCalcPvFunction Returns the System.Double present value of an annuity with fixed cash flows.
ClassCalcQuartileFunction Returns the quartile of a data set. Quartiles often are used in sales and survey data to divide populations into groups.
ClassCalcQuotientFunction Returns the integer portion of a division.
ClassCalcRadiansFunction Converts degrees to radians.
ClassCalcRandBetweenFunction Returns a random integer number between the numbers you specify.
ClassCalcRandFunction Returns an evenly distributed random real number greater than or equal to 0 and less than 1.
ClassCalcRankFunction Returns the rank of a number in a list of numbers.
ClassCalcRateFunction Returns the System.Double interest rate per period of an annuity.
ClassCalcReceivedFunction Returns the System.Double amount received at maturity for a fully invested security.
ClassCalcReplaceFunction Replaces part of a text string, based on the number of characters you specify, with a different text string.
ClassCalcReptFunction Repeats text a given number of times.
ClassCalcRightFunction returns the last character or characters in a text string, based on the number of characters you specify.
ClassCalcRomanFunction Converts an Arabic numeral to roman, as text.
ClassCalcRoundDownFunction Rounds a number down, toward zero.
ClassCalcRoundFunction Returns a number rounded to the desired multiple.
ClassCalcRoundUpFunction Rounds a number up, away from 0.
ClassCalcRowFunction Returns the row number of a reference.
ClassCalcRowsFunction Returns the number of rows in a reference or array.
ClassCalcRSqFunction Returns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's.
ClassCalcSearchFunction locate one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string.
ClassCalcSecondFunction Returns the seconds of a time value. The second is given as an System.Int32 in the range 0 (zero) to 59.
ClassCalcSeriesSumFunction Returns the sum of a power series based on the formula.
ClassCalcSignFunction Determines the sign of a number. Returns 1 if the number is positive, zero (0) if the number is 0, and -1 if the number is negative
ClassCalcSinFunction Returns the sine of the given angle.
ClassCalcSinhFunction Returns the hyperbolic sine of a number.
ClassCalcSkewFunction Returns the skew of a distribution.
ClassCalcSlnFunction Returns the System.Double straight-line depreciation of an asset for one period.
ClassCalcSlopeFunction Returns the System.Double slope of the linear regression.
ClassCalcSmallFunction Returns the smallest value in a data set.
ClassCalcSqrtFunction Returns a positive square root.
ClassCalcSqrtPiFunction Returns the square root of (number * pi).
ClassCalcStandardizeFunction Returns a normalized value from a distribution characterized by mean and standard_dev.
ClassCalcStDevAFunction Returns the System.Double standard deviation based on a sample, including text and logical values.
ClassCalcStDevFunction Returns the System.Double standard deviation based on a sample.
ClassCalcStDevPAFunction Returns the System.Double standard deviation based on the entire population, including text and logical values.
ClassCalcStDevPFunction Returns the System.Double standard deviation based on the entire population.
ClassCalcStEyxFunction Returns the System.Double standard error of the predicted y-value for each x in the regression.
ClassCalcSubstituteFunction Substitutes new_text for old_text in a text string.
ClassCalcSubtotalFunction Returns a subtotal in a list or database.
ClassCalcSumFunction Adds all the numbers.
ClassCalcSumIfFunction Adds the cells specified by a given criteria.
ClassCalcSumIfsFunction Adds the cells in a range that meet multiple criteria.
ClassCalcSumProductFunction Multiplies corresponding components in the given arrays, and returns the sum of those products.
ClassCalcSumSqFunction Returns the sum of the squares of the arguments.
ClassCalcSumX2MY2Function Returns the sum of the difference of squares of corresponding values in two arrays.
ClassCalcSumX2PY2Function Returns the sum of the sum of squares of corresponding values in two arrays.
ClassCalcSumXMY2Function Returns the sum of squares of differences of corresponding values in two arrays.
ClassCalcSydFunction Returns the System.Double sum-of-years' digits depreciation of an asset for a specified period.
ClassCalcTanFunction Returns the tangent of the given angle.
ClassCalcTanhFunction Returns the hyperbolic tangent of a number.
ClassCalcTBillEqFunction Returns the System.Double bond-equivalent yield for a Treasury bill.
ClassCalcTBillPriceFunction Returns the System.Double price per $100 face value for a Treasury bill.
ClassCalcTBillYieldFunction Returns the System.Double yield for a Treasury bill.
ClassCalcTDistFunction Returns the Percentage Points (probability) for the Student t-distribution where a numeric value (x) is a calculated value of t for which the Percentage Points are to be computed.
ClassCalcTextFunction Converts a value to text in a specific number format.
ClassCalcTFunction Returns the text referred to by value.
ClassCalcTimeFunction Returns the System.TimeSpan for a particular time.
ClassCalcTimeValueFunction Returns the System.TimeSpan represented by a text string.
ClassCalcTInvFunction Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.
ClassCalcTodayFunction Returns the System.DateTime of the current date.
ClassCalcTransposeFunction Returns a vertical range of cells as a horizontal range, or vice versa.
ClassCalcTrendFunction Returns an GrapeCity.CalcEngine.CalcArray array of y-values along a linear trend.
ClassCalcTrimFunction Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.
ClassCalcTrimMeanFunction Returns the mean of the interior of a data set.
ClassCalcTrueFunction Returns the logical value true.
ClassCalcTruncFunction Truncates a number to an integer by removing the fractional part of the number.
ClassCalcTTestFunction Returns the probability associated with a Student's t-Test.
ClassCalcTypeFunction Returns the type of value.
ClassCalcUpperFunction Converts text to uppercase.
ClassCalcValueFunction Converts a text string that represents a number to a number.
ClassCalcVarAFunction Returns the System.Double compound variance based on a sample
ClassCalcVarFunction Returns the System.Double compound variance based on a sample.
ClassCalcVarPAFunction Returns the System.Double variance based on the entire population. In addition to numbers, text and logical values such as True and False are included in the calculation.
ClassCalcVarPFunction Returns the System.Double variance based on the entire population.
ClassCalcVdbFunction Returns the System.Double amount an asset depreciates in a single period using different declining balance methods.
ClassCalcVLookupFunction Searches for a value in the first column of a table array and returns a value in the same row from another column in the table array.
ClassCalcWeekDayFunction Returns the day of the week corresponding to a date. The day is given as an System.Int32, ranging from 1 (Sunday) to 7 (Saturday), by default.
ClassCalcWeekNumFunction Returns a number that indicates where the week falls numerically within a year.
ClassCalcWeibullFunction Returns the Weibull distribution.
ClassCalcWorkdayFunction Returns a number that represents a date that is the indicated number of working days before or after a date (the starting date). Working days exclude weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed.
ClassCalcXIrrFunction Returns the System.Double internal rate of return for a schedule of cash flows that is not necessarily periodic.
ClassCalcXnpvFunction Returns the System.Double net present value for a series of cash flows not at regular intervals.
ClassCalcYearFracFunction Calculates the fraction of the year represented by the number of whole days between two dates (the start_date and the end_date). Use the YEARFRAC worksheet function to identify the proportion of a whole year's benefits or obligations to assign to a specific term.
ClassCalcYearFunction Returns the year corresponding to a date. The year is returned as an System.Int32 in the range 1900-9999.
ClassCalcYieldDiscFunction Returns the System.Double annual yield for a discounted security.
ClassCalcYieldFunction Returns the System.Double yield on a security that pays periodic interest. Use YIELD to calculate bond yield.
ClassCalcYieldMatFunction Returns the System.Double annual yield of a security that pays interest at maturity.
ClassCalcZTestFunction Returns the one-tailed probability-value of a z-test.
See Also

Reference

GrapeCity.Silverlight.CalcEngine Assembly

 

 


Copyright © GrapeCity, inc. All rights reserved.