Spread Silverlight Documentation
GrapeCity.CalcEngine.Functions Namespace
Inheritance Hierarchy
Provides the base classes and structures for the functionality for functions.
Classes
 ClassDescription
Class Returns the absolute value of a number. The absolute value of a number is the number without its sign.
ClassReturns the System.Double accrued interest for a security that pays periodic interest.
ClassReturns the System.Double accrued interest for a security that pays interest at maturity.
Class Returns the arccosine, or inverse cosine, of a number.
Class Returns the inverse hyperbolic cosine of a number.
Class Creates a cell address as text, given specified row and column numbers.
ClassReturns the System.Double depreciation for each accounting period.
ClassReturns the System.Double depreciation for each accounting period.
ClassReturns true if all its arguments are true; returns false if one or more argument is false.
Class Returns the arcsine, or inverse sine, of a number.
Class Returns the inverse hyperbolic sine of a number.
Class Returns the arctangent, or inverse tangent, of the specified x- and y-coordinates.
Class Returns the arctangent, or inverse tangent, of a number.
Class Returns the inverse hyperbolic tangent of a number.
Class Returns the average of the absolute deviations of data points from their mean.
Class Calculates the average (arithmetic mean) of the values in the list of arguments.
Class Returns the average (arithmetic mean) of the arguments.
Class Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
Class Returns the average (arithmetic mean) of all cells that meet multiple criteria.
ClassReturns the System.Double modified Bessel function, which is equivalent to the Bessel function evaluated for purely imaginary arguments.
ClassReturns the System.Double modified Bessel function represented by J(x).
ClassReturns the System.Double modified Bessel function represented by K(x).
ClassReturns the System.Double Bessel function, which is also called the Weber function or the Neumann function.
ClassReturns the System.Double cumulative beta probability density function.
ClassReturns the System.Double inverse of the cumulative beta probability density function for a specified beta distribution.
ClassReturns the System.Int32 converted from binary to decimal.
ClassReturns the System.String converted from binary to hexadecimal.
ClassReturns the System.String converted from binary to octal.
ClassReturns the System.Double individual term binomial distribution probability.
Class Represents an abstract base class for CalcEngine builtin functions.
Class Returns number rounded up, away from zero, to the nearest multiple of significance.
Class 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.
ClassReturns the System.Double one tailed probability of the chi-squared distribution.
ClassReturns the System.Double inverse of the one-tailed probability of the chi-squared distribution.
ClassReturns the System.Double value from the chi-squared distribution.
Class Uses index_num to return a value from the list of value arguments.
Class 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.
Class Returns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.
Class Returns the column number of the given reference.
Class Returns the number of columns in an array or reference.
Class Returns the number of combinations for a given number of items.
ClassReturns the System.String complex number given the real and imaginary coefficient.
Class Joins two or more text strings into one text string.
ClassReturns the System.Double confidence interval for a population mean.
ClassReturns the System.Double equivalent number when converted to another measurement system.
ClassReturns the System.Double correlation coefficient of the array1 and array2 cell ranges.
Class Returns the cosine of the given angle.
Class Returns the hyperbolic cosine of a number.
Class Counts the number of cells that are not empty and the values within the list of arguments.
Class Counts empty cells in a specified range of cells.
Class Counts the number of cells that contain numbers and counts numbers within the list of arguments.
Class Counts the number of cells within a range that meet the given criteria.
Class Counts the number of cells within a range that meet multiple criteria.
ClassReturns the System.Double number of days from the beginning of the coupon period to the settlement date.
ClassReturns the System.Double number of days in the coupon period that contains the settlement date.
ClassReturns the System.Double number of days from the settlement date to the next coupon date.
ClassReturns a System.Double number that represents the next coupon date after the settlement date.
ClassReturns the System.Double number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
ClassReturns a System.Double number that represents the previous coupon date before the settlement date.
ClassReturns the System.Double covariance of two lists of numbers.
ClassReturns the System.Double smallest number which is the cumulative binomial distribution that is greater than a criterion value.
ClassReturns the System.Double cumulative interest paid on a loan between start_period and end_period.
ClassReturns the System.Double cumulative principal paid on a loan between start_period and end_period.
Class Returns the number of days, months, or years between two dates.
ClassReturns the System.DateTime that represents a particular date.
ClassReturns the System.DateTime of the date represented by date_text.
Class Averages the values in a field (column) of records in a list or database that match conditions you specify.
ClassReturns the day of a date, represented by a serial number. The day is given as an System.Int32 ranging from 1 to 31.
Class 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.
ClassReturns the System.Double depreciation of an asset for a specified period using the fixed-declining balance method.
Class Counts the cells that contain numbers in a field (column) of records in a list or database that match conditions that you specify.
Class Counts the cells that contain numbers in a field (column) of records in a list or database that match conditions that you specify.
ClassReturns the System.Double depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.
ClassReturns the System.String converted from decimal to binary.
ClassReturns the System.String converted from decimal to hexadecimal.
ClassReturns the System.String converted from decimal to octal.
Class Converts radians into degrees.
ClassReturns the System.Int32 value indicating if two numbers are equal.
ClassReturns the System.Double sum of squares of deviations of data points from their mean.
Class Extracts a single value from a column of a list or database that matches conditions that you specify.
ClassReturns the System.Double discount rate for a security.
Class Returns the largest number in a field (column) of records in a list or database that matches conditions you that specify.
Class Returns the smallest number in a field (column) of records in a list or database that matches conditions that you specify.
ClassReturns the System.Double dollar fraction expressed as a decimal.
ClassReturns the System.Double dollar decimal expressed as a fraction.
Class 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).
Class Multiplies the values in a field (column) of records in a list or database that match conditions that you specify.
Class 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.
Class 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.
Class Adds the numbers in a field (column) of records in a list or database that match conditions that you specify.
ClassReturns the System.Double Macauley duration for an assumed par value of $100.
Class 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.
Class 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.
ClassReturns 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.
ClassReturns the System.Double effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year.
ClassReturns 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.
ClassReturns the System.Double complementary error function integrated between x and infinity.
ClassReturns the System.Double error function integrated between lower_limit and upper_limit.
Class Returns a number corresponding to one of the error values or returns the #N/A error if no error exists.
Class Converts a currency value from one source to another.
Class Returns one euro as a given national currency.
Class Returns number rounded up to the nearest even integer.
ClassCompares two text strings and returns true if they are exactly the same, false otherwise.
Class Returns e raised to the power of number.
ClassReturns the System.Double exponential distribution.
Class Returns the double factorial of a number.
Class Returns the factorial of a number.
ClassReturns the logical value false.
ClassReturns the System.Double F probability distribution.
Class 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.
ClassReturns the System.Double inverse of the F probability distribution.
ClassReturns the System.Double Fisher transformation at x.
ClassReturns the System.Double inverse of the Fisher transformation.
ClassRounds 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.
Class Rounds number down, toward zero, to the nearest multiple of significance.
ClassReturns the System.Double future value along a linear trend by using existing values.
Class Calculates how often values occur within a range of values, and then returns a vertical array of numbers.
ClassReturns the System.Double result of an F-test.
Class Represents an abstract base class for defining functions.
ClassReturns the System.Double future value of an investment based on periodic, constant payments and a constant interest rate.
ClassReturns the System.Double future value of an initial principal after applying compound interest rates.
ClassReturns the System.Double gamma distribution.
ClassReturns the System.Double inverse of the gamma cumulative distribution.
ClassReturns the System.Double natural logarithm of the gamma function, ¦£(x).
Class 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.
Class Returns the geometric mean of an array or range of positive data.
Class Returns the boolean value depending if a number is greater than a threshold value.
ClassReturns the GrapeCity.CalcEngine.CalcArray predicted exponential growth by using existing data.
Class Returns the harmonic mean of a data set. The harmonic mean is the reciprocal of the arithmetic mean of reciprocals.
ClassReturns the System.String converted from hexadecimal to binary.
ClassReturns the System.Double number converted from hexadecimal to decimal.
ClassReturns the System.String number converted from hexadecimal to octal.
Class 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.
ClassReturns 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.).
ClassReturns the System.Double hyper geometric distribution for a finite population.
Class 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 (=).).
ClassReturns one value if a condition you specify evaluates to true and another value if it evaluates to false.
ClassReturns the System.Double absolute value (modulus) of a complex number in x + yi or x + yj text format.
ClassReturns the System.Double imaginary coefficient of a complex number in x + yi or x + yj text format.
ClassReturns the System.Double argument (theta), an angle expressed in radians.
ClassReturns the System.String complex conjugate of a complex number in x + yi or x + yj text format.
ClassReturns the System.String cosine of a complex number in x + yi or x + yj text format.
ClassReturns the System.String quotient of two complex numbers in x + yi or x + yj text format.
ClassReturns the System.String exponential of a complex number in x + yi or x + yj text format.
ClassReturns the System.String natural logarithm of a complex number in x + yi or x + yj text format.
ClassReturns the System.String common logarithm (base 10) of a complex number in x + yi or x + yj text format.
ClassReturns the System.String base-2 logarithm of a complex number in x + yi or x + yj text format.
ClassReturns a System.String complex number in x + yi or x + yj text format raised to a power.
ClassReturns the System.String product of 1 to 255 complex numbers in x + yi or x + yj text format.
ClassReturns the System.Double real coefficient of a complex number in x + yi or x + yj text format.
ClassReturns the System.String sine of a complex number in x + yi or x + yj text format.
ClassReturns the System.String square root of a complex number in x + yi or x + yj text format.
ClassReturns the System.String difference of two complex numbers in x + yi or x + yj text format.
ClassReturns the System.String sum of two or more complex numbers in x + yi or x + yj text format.
Class Returns a value or the reference to a value from within a table or range.
ClassReturns the System.Double intersection with the y-axis using a linear regression plotted through known values.
Class Rounds a number down to the nearest integer.
ClassReturns the System.Double interest rate for a fully invested security.
ClassReturns the System.Double interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
ClassReturns the System.Double internal rate of return for a series of cash flows represented by the numbers in values.
Class Checks whether the value is refers to an empty cell.
Class Checks whether the value is refers to any error value except #N/A.
Class Checks whether the value is refers to any error value except #N/A.
Class Checks whether the number is even.
Class Checks whether the value is refers to a logical value.
Class Checks whether the value is refers to the #N/A (value not available) error value.
Class Checks whether the value is refers to any item that is not text.
Class Checks whether the value is refers to a number.
Class Checks whether the number is odd.
ClassReturns the System.Double interest paid during a specific period of an investment.
Class Checks whether the value is refers to a reference.
Class Checks whether the value is refers to text.
Class Returns the kurtosis of a data set.
Class Returns the k-th largest value in a data set.
Class 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.
Class Returns the first character or characters in a text string, based on the number of characters you specify.
Class Returns the number of characters in a text string.
ClassReturns the GrapeCity.CalcEngine.CalcArray coordinates for a straight line that best fits your data.
Class Returns the natural logarithm of a number.
Class Returns the base-10 logarithm of a number.
ClassReturns the GrapeCity.CalcEngine.CalcArray array of values for an exponential curve that best fits your data.
Class Returns the logarithm of a number to the base you specify.
ClassReturns the System.Double inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev
ClassReturns the System.Double cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev.
Class Returns a value either from a one-row or one-column range or from an array.
Class Converts all uppercase letters in a text string to lowercase.
Class Returns the relative position of an item in an array that matches a specified value in a specified order.
Class Returns the largest value in a list of arguments.
Class Returns the largest value in a set of values.
Class Returns the matrix determinant of an array.
ClassReturns the System.Double modified Macauley duration for a security with an assumed par value of $100.
Class Returns the median of the given numbers. The median is the number in the middle of a set of numbers.
Class Returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
Class Returns the smallest value in the list of arguments.
Class Returns the smallest number in a set of values.
ClassReturns the minutes of a time value. The minute is given as an System.Int32, ranging from 0 to 59.
Class Returns the inverse matrix for the matrix stored in an array.
ClassReturns the System.Double modified internal rate of return for a series of periodic cash flows.
Class Returns the matrix product of two arrays.
Class Returns the most frequently occurring, or repetitive, value in an array or range of data.
Class Returns the remainder after number is divided by divisor. The result has the same sign as divisor.
ClassReturns 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).
Class Returns a number rounded to the desired multiple.
Class Returns the ratio of the factorial of a sum of values to the product of factorials.
Class Returns the error value #N/A.
ClassReturns the System.Double negative binomial distribution.
Class 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.
Class Returns a value converted to a number.
ClassReturns the System.Double nominal annual interest rate, given the effective rate and the number of compounding periods per year.
ClassReturns the System.Double normal cumulative distribution.
ClassReturns the System.Double inverse of the normal cumulative distribution.
ClassReturns the System.Double standard normal cumulative distribution.
ClassReturns the System.Double inverse of the standard normal cumulative distribution.
Class Reverses the value of its argument. Use NOT when you want to make sure a value is not equal to one particular value.
ClassReturns the System.DateTime of the current date and time.
ClassReturns the System.Double number of periods for an investment based on periodic, constant payments and a constant interest rate.
ClassReturns the System.Double net present value of a series of cash flows (in and out).
ClassReturns the System.String number converted from octal to binary.
ClassReturns the System.Double number converted from octal to decimal.
ClassReturns the System.String number converted from octal to hexadecimal.
ClassReturns the System.Double price per $100 face value of a security having an odd (short or long) first period.
Class Returns number rounded up to the nearest odd integer.
ClassReturns the System.Double yield of a security that has an odd (short or long) first period.
ClassReturns the System.Double price per $100 face value of a security having an odd (short or long) last coupon period.
ClassReturns the System.Double yield of a security that has an odd (short or long) last period.
Class Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.
ClassReturns true if any argument is true; returns false if all arguments are false.
ClassReturns the System.Double Pearson product moment correlation coefficient.
Class Returns the k-th percentile of values in a range.
Class Returns the rank of a value in a data set as a percentage of the data set.
ClassReturns the System.Double number of permutations from a given number.
Class Returns the mathematical constant pi.
ClassReturns the System.Double payment for a loan with constant payments and fixed interest.
Class Returns the Poisson distribution.
Class Returns the result of a number raised to a power.
ClassReturns the System.Double payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.
ClassReturns the System.Double price per $100 face value of a discounted security.
ClassReturns the System.Double price per $100 face value of a security that pays periodic interest.
ClassReturns the System.Double price per $100 face value of a security that pays interest at maturity.
Class Returns the probability that values in a range are between two limits.
Class Multiplies all the numbers given as arguments and returns the product.
Class 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.
ClassReturns the System.Double present value of an annuity with fixed cash flows.
Class Returns the quartile of a data set. Quartiles often are used in sales and survey data to divide populations into groups.
Class Returns the integer portion of a division.
Class Converts degrees to radians.
Class Returns a random integer number between the numbers you specify.
Class Returns an evenly distributed random real number greater than or equal to 0 and less than 1.
Class Returns the rank of a number in a list of numbers.
ClassReturns the System.Double interest rate per period of an annuity.
ClassReturns the System.Double amount received at maturity for a fully invested security.
Class Replaces part of a text string, based on the number of characters you specify, with a different text string.
Class Repeats text a given number of times.
Class returns the last character or characters in a text string, based on the number of characters you specify.
Class Converts an Arabic numeral to roman, as text.
Class Rounds a number down, toward zero.
Class Returns a number rounded to the desired multiple.
Class Rounds a number up, away from 0.
Class Returns the row number of a reference.
Class Returns the number of rows in a reference or array.
Class Returns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's.
Class 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.
ClassReturns the seconds of a time value. The second is given as an System.Int32 in the range 0 (zero) to 59.
Class Returns the sum of a power series based on the formula.
Class 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
Class Returns the sine of the given angle.
Class Returns the hyperbolic sine of a number.
Class Returns the skew of a distribution.
ClassReturns the System.Double straight-line depreciation of an asset for one period.
ClassReturns the System.Double slope of the linear regression.
Class Returns the smallest value in a data set.
Class Returns a positive square root.
Class Returns the square root of (number * pi).
Class Returns a normalized value from a distribution characterized by mean and standard_dev.
ClassReturns the System.Double standard deviation based on a sample, including text and logical values.
ClassReturns the System.Double standard deviation based on a sample.
ClassReturns the System.Double standard deviation based on the entire population, including text and logical values.
ClassReturns the System.Double standard deviation based on the entire population.
ClassReturns the System.Double standard error of the predicted y-value for each x in the regression.
Class Substitutes new_text for old_text in a text string.
Class Returns a subtotal in a list or database.
Class Adds all the numbers.
Class Adds the cells specified by a given criteria.
Class Adds the cells in a range that meet multiple criteria.
Class Multiplies corresponding components in the given arrays, and returns the sum of those products.
Class Returns the sum of the squares of the arguments.
Class Returns the sum of the difference of squares of corresponding values in two arrays.
Class Returns the sum of the sum of squares of corresponding values in two arrays.
Class Returns the sum of squares of differences of corresponding values in two arrays.
ClassReturns the System.Double sum-of-years' digits depreciation of an asset for a specified period.
Class Returns the tangent of the given angle.
Class Returns the hyperbolic tangent of a number.
ClassReturns the System.Double bond-equivalent yield for a Treasury bill.
ClassReturns the System.Double price per $100 face value for a Treasury bill.
ClassReturns the System.Double yield for a Treasury bill.
Class 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.
Class Converts a value to text in a specific number format.
Class Returns the text referred to by value.
ClassReturns the System.TimeSpan for a particular time.
ClassReturns the System.TimeSpan represented by a text string.
Class Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom.
ClassReturns the System.DateTime of the current date.
Class Returns a vertical range of cells as a horizontal range, or vice versa.
ClassReturns an GrapeCity.CalcEngine.CalcArray array of y-values along a linear trend.
Class 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.
Class Returns the mean of the interior of a data set.
ClassReturns the logical value true.
Class Truncates a number to an integer by removing the fractional part of the number.
Class Returns the probability associated with a Student's t-Test.
Class Returns the type of value.
Class Converts text to uppercase.
Class Converts a text string that represents a number to a number.
ClassReturns the System.Double compound variance based on a sample
ClassReturns the System.Double compound variance based on a sample.
ClassReturns 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.
ClassReturns the System.Double variance based on the entire population.
ClassReturns the System.Double amount an asset depreciates in a single period using different declining balance methods.
Class 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.
ClassReturns 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.
Class Returns a number that indicates where the week falls numerically within a year.
Class Returns the Weibull distribution.
Class 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.
ClassReturns the System.Double internal rate of return for a schedule of cash flows that is not necessarily periodic.
ClassReturns the System.Double net present value for a series of cash flows not at regular intervals.
Class 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.
ClassReturns the year corresponding to a date. The year is returned as an System.Int32 in the range 1900-9999.
ClassReturns the System.Double annual yield for a discounted security.
ClassReturns the System.Double yield on a security that pays periodic interest. Use YIELD to calculate bond yield.
ClassReturns the System.Double annual yield of a security that pays interest at maturity.
Class Returns the one-tailed probability-value of a z-test.
See Also

Reference

GrapeCity.Silverlight.CalcEngine Assembly