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