Telerik.Windows.Documents.Spreadsheet.Expressions.Functions
Calculates the absolute value of a number, removing its sign.
Calculates accrued interest for a security that pays interest at maturity and returns the total interest amount accrued from issue to settlement date.
Calculates the arccosine (inverse cosine) of a number and returns the angle in radians within the range 0 to π.
Calculates the inverse hyperbolic cosine of a number, accepting values greater than or equal to 1.
Calculates the arccotangent (inverse cotangent) of a number and returns the principal value of the angle in radians.
Calculates the inverse hyperbolic cotangent of a number, requiring an absolute value greater than 1.
Calculates depreciation for each accounting period using the French accounting system and returns the depreciated amount with coefficient adjustments based on asset life and prorated for partial periods.
Calculates linear depreciation for each accounting period using the French accounting system and returns the depreciated amount prorated for partial periods.
Implements the AND function, which evaluates multiple conditions and returns TRUE only if all arguments are TRUE.
Defines how a function converts and interprets different argument types during evaluation, controlling behavior for direct vs. indirect references, empty values, booleans, and text. Use predefined rule sets for common function categories.
Metadata describing a function argument including its name, expected type, description, and whether it is required or optional. Use this for function documentation and validation.
Defines how a function argument value should be interpreted during evaluation: used as-is, treated as error, ignored, or converted to a default value.
Categorizes function arguments by their expected data type for validation and documentation purposes.
Defines how array arguments should be interpreted: use the first element only, use all elements, or ignore all elements.
Calculates the arcsine (inverse sine) of a number and returns the angle in radians within the range -π/2 to π/2.
Calculates the inverse hyperbolic sine of a number, accepting any real value.
Calculates the arctangent (inverse tangent) of a number and returns the angle in radians within the range -π/2 to π/2.
Calculates the arctangent of the specified x and y coordinates and returns the angle from the x-axis to the point in radians, within the range -π to π.
Implements the ATANH function, which calculates the inverse hyperbolic tangent of a number.
Implements the AVERAGE function, which calculates the arithmetic mean of numeric arguments.
Implements the AVERAGEA function, which calculates the arithmetic mean including text and logical values converted to numbers.
Implements the BESSELI function, computing the modified Bessel function In(x) for purely imaginary arguments.
Implements the BESSELJ function, computing the Bessel function Jn(x) of the first kind.
Implements the BESSELK function, computing the modified Bessel function Kn(x) of the second kind for purely imaginary arguments.
Implements the BESSELY function, computing the Bessel function Yn(x) of the second kind, also known as the Weber or Neumann function.
Implements the BIN2DEC function, converting a binary string up to 10 bits into its decimal integer equivalent.
Implements the BIN2HEX function, converting a binary string up to 10 bits into its hexadecimal string representation.
Implements the BIN2OCT function, converting a binary string up to 10 bits into its octal string representation.
Implements the BITAND function, performing a bitwise AND operation on two integers in the range 0 to 2⁴⁸−1.
Implements the BITLSHIFT function, shifting an integer left by a specified number of bits up to ±53 positions.
Implements the BITOR function, performing a bitwise OR operation on two integers in the range 0 to 2⁴⁸−1.
Implements the BITRSHIFT function, shifting an integer right by a specified number of bits up to ±53 positions.
Implements the BITXOR function, performing a bitwise exclusive OR operation on two integers in the range 0 to 2⁴⁸−1.
Abstract base for functions that accept boolean arguments, applying boolean-specific conversion rules during evaluation.
Implements the CEILING function, which rounds a number up to the nearest multiple of a specified significance.
Implements the CEILING.MATH function, which rounds a number up to the nearest integer or multiple of significance with optional mode control for negative numbers.
Implements the CEILING.PRECISE function, which rounds a number up to the nearest integer or multiple of significance regardless of sign.
Implements the CHAR function, which converts a numeric code (1-255) to its corresponding character.
Implements the CODE function, which returns the numeric code of the first character in a text string.
Implements the COMBIN function, which calculates the number of combinations for selecting items from a set without regard to order.
Implements the COMPLEX function, constructing a complex number string in the form x + yi or x + yj from real and imaginary coefficients.
Implements the CONCAT function, which combines multiple text strings and ranges into a single concatenated string.
Implements the CONCATENATE function, which joins multiple text strings into a single combined string.
Converts a numeric value from one measurement system to another, supporting conversions between compatible unit types such as distance, weight, temperature, and other measurement categories.
Implements the COS function, which calculates the cosine of an angle specified in radians.
Implements the COSH function, which calculates the hyperbolic cosine of a number.
Implements the COT function, which calculates the cotangent of an angle specified in radians.
Implements the COTH function, which calculates the hyperbolic cotangent of a number.
Implements the COUNTIF function, which counts cells in a range that meet a specified criteria.
Calculates the number of days from the coupon period start to the settlement date and returns the day count for interest accrual calculations.
Calculates the total number of days in the coupon period containing the settlement date and returns the period length for yield calculations.
Calculates the number of days from the settlement date to the next coupon date and returns the day count for interest period calculations.
Calculates the next coupon date after the settlement date and returns it as a serial date number for scheduling and valuation.
Calculates the number of coupons payable between settlement and maturity and returns the count rounded up to the nearest whole coupon for payment scheduling.
Calculates the previous coupon date before the settlement date and returns it as a serial date number for accrued interest calculations.
Implements the CSC function, which calculates the cosecant of an angle specified in radians.
Implements the CSCH function, which calculates the hyperbolic cosecant of an angle in radians.
Calculates cumulative interest paid on a loan between specified periods and returns the total interest amount for the period range.
Calculates cumulative principal paid on a loan between specified periods and returns the total principal amount for the period range.
Implements the DATE function that constructs a date serial number from year, month, and day components, returning a formatted date value.
Implements the DATEVALUE function that parses a text string into a date serial number, allowing conversion of date strings to numeric values.
Implements the DAY function that extracts the day component (1-31) from a date serial number.
Implements the DAYS function that calculates the number of days between two dates by subtracting start date from end date.
Calculates depreciation for a specified period using the fixed-declining balance method and returns the depreciation amount for that period.
Converts a decimal integer to its binary representation, optionally padding to a specified number of characters, with support for signed 10-bit values.
Converts a decimal integer to its hexadecimal representation, optionally padding to a specified number of characters, with support for signed 40-bit values.
Converts a decimal integer to its octal representation, optionally padding to a specified number of characters, with support for signed 30-bit values.
Implements the DEGREES function, which converts radians to degrees.
Tests whether two numeric values are equal and returns 1 if they match or 0 otherwise, useful for filtering and counting matching pairs through summation of multiple DELTA results.
Calculates the discount rate for a security and returns the annual rate as a decimal value.
Converts a dollar price from fractional notation to decimal notation and returns the decimal price value.
Converts decimal dollar values to fractional dollar notation used in securities pricing.
Calculates the Macauley duration of a security as the weighted average of present value cash flows, measuring bond price sensitivity to yield changes.
Calculates the effective annual interest rate from a nominal rate and compounding frequency.
Computes the error function integrated between two bounds, or from zero to a single bound, commonly used in statistics and probability calculations.
Computes the complementary error function integrated from a lower bound to infinity, providing the complement of the standard error function.
Computes the complementary error function integrated from a lower bound to infinity with precise calculation, providing the complement of the standard error function.
Computes the error function integrated from zero to a specified upper bound with precise calculation, commonly used in statistics and probability calculations.
Implements the ERROR.TYPE function, which maps error values to numeric codes (1-7) and returns #N/A if no error exists.
Implements the EVEN function, which rounds numbers up to the nearest even integer.
Implements the EXACT function, which performs case-sensitive comparison of two text strings and returns TRUE if identical.
Implements the EXP function, which raises Euler's number (e) to a specified power.
Implements the FACT function, which calculates the factorial of a non-negative integer.
Implements the FACTDOUBLE function, which calculates the double factorial of a number (product of every other integer).
Implements the FALSE function, which returns the boolean value FALSE.
Implements the FIND function, which locates one text string within another and returns the starting position (case-sensitive).
Implements the FLOOR function, which rounds a number down toward zero to the nearest multiple of significance.
Implements the FLOOR.MATH function, which rounds a number down to the nearest integer or multiple with optional mode control for negative values.
Implements the FLOOR.PRECISE function, which rounds a number down to the nearest multiple regardless of sign.
Abstract base for all spreadsheet functions, defining evaluation logic, argument rules, and metadata for use in formula expressions.
Categorizes spreadsheet functions by domain (Financial, DateTime, MathTrig, Statistical, etc.) for organizational and discovery purposes.
Encapsulates the context for function evaluation, including arguments, worksheet reference, and cell position where the function is invoked.
Metadata describing a spreadsheet function's signature, including name, category, argument definitions, and result format.
Central registry for managing spreadsheet functions, enabling registration, unregistration, and lookup of built-in and custom functions by name.
Base class for spreadsheet functions that accept arguments, handling argument conversion, validation, and typed evaluation.
Base class for functions requiring all arguments to be of the same type, automatically converting object arguments to the specified type.
Calculates the future value of an investment with periodic constant payments and a constant interest rate.
Tests whether a numeric value meets or exceeds a threshold and returns 1 if true or 0 otherwise, useful for filtering and counting values that exceed a threshold through summation.
Implements the GCD function, which finds the greatest common divisor of two or more integers.
Implements the HLOOKUP function, which searches for a value in the top row of a table and returns a value from a specified row in the same column.
Converts a hexadecimal number to binary representation, optionally padded to a specified length.
Converts a hexadecimal number to decimal representation.
Converts a hexadecimal number to octal representation, optionally padded to a specified length.
Implements the HOUR function that extracts the hour component (0-23) from a time serial number.
Implements the HYPERLINK function, which creates a clickable hyperlink to a document, web page, or email address and displays optional friendly text.
Implements the IF function, which evaluates a logical condition and returns one value when TRUE and another when FALSE.
Computes the absolute value (modulus) of a complex number provided in x+yi or x+yj text format.
Computes the argument θ (theta) of a complex number, expressed as an angle in radians.
Computes the complex conjugate of a complex number provided in x+yi or x+yj text format.
Computes the cosine of a complex number provided in x+yi or x+yj text format.
Computes the hyperbolic cosine of a complex number provided in x+yi or x+yj text format.
Computes the cotangent of a complex number provided in x+yi or x+yj text format.
Computes the cosecant of a complex number provided in x+yi or x+yj text format.
Computes the hyperbolic cosecant of a complex number provided in x+yi or x+yj text format.
Divides two complex numbers and returns the quotient in x+yi or x+yj text format.
Computes the exponential of a complex number provided in x+yi or x+yj text format.
Computes the natural logarithm of a complex number provided in x+yi or x+yj text format.
Computes the base-10 logarithm of a complex number in x+yi or x+yj text format.
Computes the base-2 logarithm of a complex number in x+yi or x+yj text format.
Raises a complex number in x+yi or x+yj text format to a specified power.
Multiplies 1 to 255 complex numbers in x+yi or x+yj text format and returns their product.
Extracts the real coefficient from a complex number in x+yi or x+yj text format.
Computes the secant of a complex number in x+yi or x+yj text format.
Computes the hyperbolic secant of a complex number in x+yi or x+yj text format.
Computes the sine of a complex number in x+yi or x+yj text format.
Computes the hyperbolic sine of a complex number in x+yi or x+yj text format.
Computes the square root of a complex number in x+yi or x+yj text format.
Subtracts one complex number from another in x+yi or x+yj text format and returns the difference.
Adds 1 to 255 complex numbers in x+yi or x+yj text format and returns their sum.
Computes the tangent of a complex number in x+yi or x+yj text format.
Extracts the imaginary coefficient from a complex number provided in x+yi or x+yj text format.
Implements the INDEX function, which returns the cell reference or value at the intersection of a specified row and column within a range or array.
Implements the INDIRECT function, which evaluates a text string as a cell reference and returns the reference to that cell or range.
Implements the INT function, which rounds a number down to the nearest integer by removing the fractional part.
Calculates the interest rate for a fully invested security based on settlement, maturity, investment, and redemption values.
Calculates the interest portion of a payment for a specific period in an investment with periodic constant payments and a constant interest rate.
Tests whether a cell reference is empty and returns TRUE for blank cells, FALSE otherwise.
Tests whether a value is any error except #N/A and returns TRUE for errors other than #N/A, FALSE otherwise.
Tests whether a value is any error and returns TRUE for any error value including #N/A, FALSE otherwise.
Tests whether a number is even and returns TRUE for even numbers, FALSE for odd numbers.
Tests whether a cell reference contains a formula and returns TRUE for formula cells, FALSE otherwise.
Tests whether a value is a boolean (TRUE or FALSE) and returns TRUE for logical values, FALSE otherwise.
Tests whether a value is the #N/A error and returns TRUE for #N/A errors, FALSE otherwise.
Tests whether a value is not text and returns TRUE for non-text values, FALSE for text.
Tests whether a value is a number and returns TRUE for numeric values, FALSE otherwise.
Tests whether a number is odd and returns TRUE for odd numbers, FALSE for even numbers.
Implements the ISREF function, which tests whether a value is a cell reference and returns TRUE for references or FALSE otherwise.
Implements the ISTEXT function, which tests whether a value is text and returns TRUE for text values or FALSE otherwise.
Implements the ISO.CEILING function, which rounds a number up to the nearest integer or specified multiple of significance, always rounding toward positive infinity regardless of sign.
Calculates the interest paid during a specific period of an investment using straight-line amortization, provided for Lotus 1-2-3 compatibility.
Implements the LCM function, which calculates the least common multiple of integers—the smallest positive integer divisible by all provided values.
Implements the LEFT function, which extracts a specified number of characters from the beginning of a text string.
Implements the LEN function, which counts the total number of characters in a text string including spaces.
Implements the LN function, which calculates the natural logarithm (base e) of a positive number.
Implements the LOG function, which calculates the logarithm of a positive number with a specified base, defaulting to base 10 if no base is provided.
Implements the LOG10 function, which calculates the base-10 logarithm of a positive number.
Implements the LOOKUP function, which searches for a value in a single-row or single-column range and returns a corresponding value from another range.
Abstract base for table lookup functions such as VLOOKUP, HLOOKUP, and LOOKUP, providing shared logic for searching and matching values in ranges.
Implements the LOWER function, which converts all uppercase letters in a text string to lowercase.
Calculates the modified Macauley duration of a security, which adjusts duration for yield changes and measures interest rate sensitivity at $100 par value.
Implements the MROUND function, which rounds a number to the nearest specified multiple, rounding away from zero when the remainder is at least half the multiple.
Implements the MAX function, which finds the largest numeric value among the arguments.
Implements the MAXA function, which finds the largest value among arguments including text and logical values converted to numbers.
Implements the MEDIAN function, which calculates the middle value in a sorted set of numbers.
Extracts a substring from text at a specified position and length; implements the MID text function.
Implements the MIN function, which finds the smallest numeric value among the arguments.
Implements the MINA function, which finds the smallest value among arguments including text and logical values converted to numbers.
Implements the MINUTE function, extracting the minute component from a time serial number and returning an integer 0–59.
Implements the MOD function, which calculates the remainder after dividing a number by a divisor, returning a result with the same sign as the divisor.
Implements the MODE function, which finds the most frequently occurring value in a dataset.
Implements the MONTH function, extracting the month component from a date serial number and returning an integer 1–12.
Implements the MULTINOMIAL function, which calculates the ratio of the factorial of a sum of values to the product of their individual factorials.
Implements the N function, which converts a value to a number, returning numeric values directly and 0 for other types.
Implements the NA function, which returns the #N/A error value to indicate missing or unavailable data.
Calculates the number of payment periods for an investment with periodic constant payments and a constant interest rate.
Calculates the nominal annual interest rate from an effective rate and compounding frequency.
Implements the NOT function, which reverses the boolean value of its argument, returning FALSE for TRUE and TRUE for FALSE.
Calculates the net present value of an investment using a discount rate and a series of future cash flows.
Base class for functions that accept numeric (double) arguments with automatic conversion rules.
Converts an octal number to binary with optional zero-padding.
Converts an octal number to its decimal representation.
Converts an octal number to hexadecimal and returns the formatted hexadecimal string, with optional padding to a specified number of characters. It supports up to 10 octal characters.
Implements the ODD function, which rounds positive numbers up and negative numbers down to the nearest odd integer.
Calculates the price per $100 face value of a security with an odd (short or long) first coupon period.
Calculates the yield of a security with an odd (short or long) first coupon period.
Calculates the price per $100 face value of a security with an odd (short or long) last coupon period.
Calculates the yield of a security with an odd (short or long) last coupon period.
Implements the OR function, which evaluates multiple conditions and returns TRUE if any argument is TRUE.
Calculates the number of periods required for an investment to reach a target future value at a constant interest rate.
Returns the mathematical constant Pi (approximately 3.14159265358979), accurate to 15 digits, for use in trigonometric and geometric calculations.
Calculates the periodic payment for a loan or annuity with constant payments and a constant interest rate.
Raises a number to a specified power and returns the result, supporting both integer and fractional exponents.
Calculates the principal portion of a loan payment for a specific period with constant payments and a constant interest rate.
Calculates the price per $100 face value of a security that pays periodic interest.
Calculates the price per $100 face value of a discounted security that does not pay periodic interest.
Multiplies all numeric arguments and returns the product, accepting up to 255 arguments including ranges.
Implements the PV financial function that calculates the present value of an investment based on periodic payments and interest rate.
Divides one number by another and returns the integer portion of the result, discarding the remainder.
Converts an angle from degrees to radians for use in trigonometric calculations.
Implements the RATE financial function that calculates the interest rate per period for an annuity using iterative approximation.
Implements the RECEIVED financial function that calculates the amount received at maturity for a fully invested security.
Repeats text a specified number of times; implements the REPT text function.
Extracts the last characters from text based on a specified count; implements the RIGHT text function.
Rounds a number to a specified number of decimal places using standard rounding rules (0.5 rounds up).
Rounds a number down toward zero to a specified number of decimal places, truncating rather than rounding up.
Rounds a number up away from zero to a specified number of decimal places, always rounding in the positive direction.
Implements the RRI financial function that calculates the equivalent interest rate for investment growth over a specified period.
Locates text within another text string using case-insensitive matching and returns the starting position; implements the SEARCH text function.
Calculates the secant of an angle specified in radians, returning 1/cos(angle).
Calculates the hyperbolic secant of a number specified in radians, returning 1/cosh(angle).
Implements the SECOND function, extracting the second component from a time serial number and returning an integer 0–59.
Determines the sign of a number and returns 1 for positive, -1 for negative, or 0 for zero.
Calculates the sine of an angle specified in radians for trigonometric calculations.
Calculates the hyperbolic sine of a number for hyperbolic trigonometric calculations.
Implements the SLN financial function that calculates straight-line depreciation of an asset for a single period.
Calculates the square root of a positive number, returning an error for negative values.
Calculates the square root of a number multiplied by Pi, returning sqrt(number × π) for geometric calculations.
Implements the STDEV function, which calculates sample standard deviation to measure data dispersion from the mean.
Implements the STDEVA function, which calculates sample standard deviation including text and logical values in the dataset.
Implements the STDEVP function, which calculates population standard deviation treating arguments as the entire population.
Implements the STDEVPA function, which calculates population standard deviation including text and logical values in the dataset.
Base class for spreadsheet functions that accept string arguments and handle string-based calculations.
Implements the SUM function, which adds all numeric values in the specified arguments.
Implements the SUMIF function, which sums values in a range that meet a specified criteria.
Implements the SUMSQ function, which calculates the sum of the squares of numeric arguments.
Implements the SYD financial function that calculates sum-of-years' digits depreciation for a specific period, which accelerates depreciation in early asset life.
Implements the TBILLEQ financial function that calculates the bond-equivalent yield for a Treasury bill.
Implements the TBILLPRICE financial function that calculates the price per $100 face value for a Treasury bill.
Implements the TBILLYIELD financial function that calculates the yield for a Treasury bill based on settlement, maturity, and price.
Implements the TAN function, which calculates the tangent of an angle in radians.
Implements the TANH function, which calculates the hyperbolic tangent of a number.
Implements the TIME function, constructing a time serial number from separate hour, minute, and second components.
Implements the TIMEVALUE function, parsing text-formatted time strings into time serial numbers in the range 0–0.99999999.
Implements the TODAY function, returning the current date as a serial number without a time component.
Removes extra spaces from text, leaving only single spaces between words; implements the TRIM text function.
Implements the TRUE function, which returns the boolean constant TRUE without requiring any arguments.
Implements the TRUNC function, which truncates a number to a specified precision by removing fractional digits.
Implements the TYPE function, which returns a numeric code indicating the data type of a value (1=number, 2=text, 4=boolean, 16=error, 64=array).
Converts text to uppercase letters; implements the UPPER text function.
Searches the leftmost column of a table for a value and returns a match from a specified column in the same row, supporting both exact and approximate matching.
Implements the VDB financial function that calculates variable declining balance depreciation for any period, with optional switching to straight-line depreciation.
Implements the XOR function, which returns TRUE when an odd number of logical arguments are TRUE and FALSE when an even number are TRUE.
Implements the YEAR function, extracting the year component from a date serial number and returning an integer 1900–9999.
Implements the YIELD financial function, which calculates the annual yield for a security with periodic interest payments.
Implements the YIELDDISC financial function, which calculates the annual yield for a discounted security that does not pay periodic interest.
Implements the YIELDMAT financial function, which calculates the annual yield for a security that pays interest at maturity.