Spread WinRT Documentation
Inheritance Hierarchy
In This Topic
    GrapeCity.CalcEngine.Functions Namespace
    In This Topic
    Classes
     ClassDescription
    ClassReturns 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.
    ClassReturns the arccosine, or inverse cosine, of a number.
    ClassReturns the inverse hyperbolic cosine of a number.
    ClassCreates 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.
    ClassReturns the arcsine, or inverse sine, of a number.
    ClassReturns the inverse hyperbolic sine of a number.
    ClassReturns the arctangent, or inverse tangent, of the specified x- and y-coordinates.
    ClassReturns the arctangent, or inverse tangent, of a number.
    ClassReturns the inverse hyperbolic tangent of a number.
    ClassReturns the average of the absolute deviations of data points from their mean.
    ClassCalculates the average (arithmetic mean) of the values in the list of arguments.
    ClassReturns the average (arithmetic mean) of the arguments.
    ClassReturns the average (arithmetic mean) of all the cells in a range that meet a given criteria.
    ClassReturns 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.
    ClassRepresents an abstract base class for CalcEngine builtin functions.
    ClassReturns number rounded up, away from zero, to the nearest multiple of significance.
    ClassReturns 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.
    ClassUses index_num to return a value from the list of value arguments.
    ClassRemoves 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.
    ClassReturns a numeric code for the first character in a text string. The returned code corresponds to the character set used by your computer.
    ClassReturns the column number of the given reference.
    ClassReturns the number of columns in an array or reference.
    ClassReturns the number of combinations for a given number of items.
    ClassReturns the System.String complex number given the real and imaginary coefficient.
    ClassJoins 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.
    ClassReturns the cosine of the given angle.
    ClassReturns the hyperbolic cosine of a number.
    ClassCounts the number of cells that are not empty and the values within the list of arguments.
    ClassCounts empty cells in a specified range of cells.
    ClassCounts the number of cells that contain numbers and counts numbers within the list of arguments.
    ClassCounts the number of cells within a range that meet the given criteria.
    ClassCounts 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.
    ClassReturns 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.
    ClassAverages 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.
    ClassReturns 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.
    ClassCounts the cells that contain numbers in a field (column) of records in a list or database that match conditions that you specify.
    ClassCounts 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.
    ClassConverts 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.
    ClassExtracts 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.
    ClassReturns the largest number in a field (column) of records in a list or database that matches conditions you that specify.
    ClassReturns 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.
    ClassThe 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).
    ClassMultiplies the values in a field (column) of records in a list or database that match conditions that you specify.
    ClassEstimates 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.
    ClassCalculates 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.
    ClassAdds 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.
    ClassEstimates 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.
    ClassCalculates 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.
    ClassReturns a number corresponding to one of the error values or returns the #N/A error if no error exists.
    ClassConverts a currency value from one source to another.
    ClassReturns one euro as a given national currency.
    ClassReturns number rounded up to the nearest even integer.
    ClassCompares two text strings and returns true if they are exactly the same, false otherwise.
    ClassReturns e raised to the power of number.
    ClassReturns the System.Double exponential distribution.
    ClassReturns the double factorial of a number.
    ClassReturns the factorial of a number.
    ClassReturns the logical value false.
    ClassReturns the System.Double F probability distribution.
    ClassLocate 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.
    ClassRounds number down, toward zero, to the nearest multiple of significance.
    ClassReturns the System.Double future value along a linear trend by using existing values.
    ClassCalculates 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.
    ClassRepresents 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).
    ClassReturns 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.
    ClassReturns the geometric mean of an array or range of positive data.
    ClassReturns 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.
    ClassReturns 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.
    ClassSearches 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.
    ClassReturns 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.
    ClassReturns 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.
    ClassRounds 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.
    ClassChecks whether the value is refers to an empty cell.
    ClassChecks whether the value is refers to any error value except #N/A.
    ClassChecks whether the value is refers to any error value except #N/A.
    ClassChecks whether the number is even.
    ClassChecks whether the value is refers to a logical value.
    ClassChecks whether the value is refers to the #N/A (value not available) error value.
    ClassChecks whether the value is refers to any item that is not text.
    ClassChecks whether the value is refers to a number.
    ClassChecks whether the number is odd.
    ClassReturns the System.Double interest paid during a specific period of an investment.
    ClassChecks whether the value is refers to a reference.
    ClassChecks whether the value is refers to text.
    ClassReturns the kurtosis of a data set.
    ClassReturns the k-th largest value in a data set.
    ClassReturns 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.
    ClassReturns the first character or characters in a text string, based on the number of characters you specify.
    ClassReturns the number of characters in a text string.
    ClassReturns the GrapeCity.CalcEngine.CalcArray coordinates for a straight line that best fits your data.
    ClassReturns the natural logarithm of a number.
    ClassReturns the base-10 logarithm of a number.
    ClassReturns the GrapeCity.CalcEngine.CalcArray array of values for an exponential curve that best fits your data.
    ClassReturns 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.
    ClassReturns a value either from a one-row or one-column range or from an array.
    ClassConverts all uppercase letters in a text string to lowercase.
    ClassReturns the relative position of an item in an array that matches a specified value in a specified order.
    ClassReturns the largest value in a list of arguments.
    ClassReturns the largest value in a set of values.
    ClassReturns the matrix determinant of an array.
    ClassReturns the System.Double modified Macauley duration for a security with an assumed par value of $100.
    ClassReturns the median of the given numbers. The median is the number in the middle of a set of numbers.
    ClassReturns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.
    ClassReturns the smallest value in the list of arguments.
    ClassReturns 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.
    ClassReturns 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.
    ClassReturns the matrix product of two arrays.
    ClassReturns the most frequently occurring, or repetitive, value in an array or range of data.
    ClassReturns 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).
    ClassReturns a number rounded to the desired multiple.
    ClassReturns the ratio of the factorial of a sum of values to the product of factorials.
    ClassReturns the error value #N/A.
    ClassReturns the System.Double negative binomial distribution.
    ClassReturns 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.
    ClassReturns 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.
    ClassReverses 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.
    ClassReturns 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.
    ClassReturns 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.
    ClassReturns the k-th percentile of values in a range.
    ClassReturns 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.
    ClassReturns the mathematical constant pi.
    ClassReturns the System.Double payment for a loan with constant payments and fixed interest.
    ClassReturns the Poisson distribution.
    ClassReturns 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.
    ClassReturns the probability that values in a range are between two limits.
    ClassMultiplies all the numbers given as arguments and returns the product.
    ClassCapitalizes 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.
    ClassReturns the quartile of a data set. Quartiles often are used in sales and survey data to divide populations into groups.
    ClassReturns the integer portion of a division.
    ClassConverts degrees to radians.
    ClassReturns a random integer number between the numbers you specify.
    ClassReturns an evenly distributed random real number greater than or equal to 0 and less than 1.
    ClassReturns 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.
    ClassReplaces part of a text string, based on the number of characters you specify, with a different text string.
    ClassRepeats text a given number of times.
    Classreturns the last character or characters in a text string, based on the number of characters you specify.
    ClassConverts an Arabic numeral to roman, as text.
    ClassRounds a number down, toward zero.
    ClassReturns a number rounded to the desired multiple.
    ClassRounds a number up, away from 0.
    ClassReturns the row number of a reference.
    ClassReturns the number of rows in a reference or array.
    ClassReturns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's.
    Classlocate 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.
    ClassReturns the sum of a power series based on the formula.
    ClassDetermines 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
    ClassReturns the sine of the given angle.
    ClassReturns the hyperbolic sine of a number.
    ClassReturns 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.
    ClassReturns the smallest value in a data set.
    ClassReturns a positive square root.
    ClassReturns the square root of (number * pi).
    ClassReturns 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.
    ClassSubstitutes new_text for old_text in a text string.
    ClassReturns a subtotal in a list or database.
    ClassAdds all the numbers.
    ClassAdds the cells specified by a given criteria.
    ClassAdds the cells in a range that meet multiple criteria.
    ClassMultiplies corresponding components in the given arrays, and returns the sum of those products.
    ClassReturns the sum of the squares of the arguments.
    ClassReturns the sum of the difference of squares of corresponding values in two arrays.
    ClassReturns the sum of the sum of squares of corresponding values in two arrays.
    ClassReturns 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.
    ClassReturns the tangent of the given angle.
    ClassReturns 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.
    ClassReturns 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.
    ClassConverts a value to text in a specific number format.
    ClassReturns the text referred to by value.
    ClassReturns the System.TimeSpan for a particular time.
    ClassReturns the System.TimeSpan represented by a text string.
    ClassReturns 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.
    ClassReturns 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.
    ClassRemoves 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.
    ClassReturns the mean of the interior of a data set.
    ClassReturns the logical value true.
    ClassTruncates a number to an integer by removing the fractional part of the number.
    ClassReturns the probability associated with a Student's t-Test.
    ClassReturns the type of value.
    ClassConverts text to uppercase.
    ClassConverts 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.
    ClassSearches 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.
    ClassReturns a number that indicates where the week falls numerically within a year.
    ClassReturns the Weibull distribution.
    ClassReturns 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.
    ClassCalculates 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.
    ClassReturns the one-tailed probability-value of a z-test.
    See Also