Namespace Telerik.Windows.Documents.Spreadsheet.Expressions.Functions

Classes

Abs Calculates the absolute value of a number, removing its sign.

AccrIntM Calculates accrued interest for a security that pays interest at maturity and returns the total interest amount accrued from issue to settlement date.

Acos Calculates the arccosine (inverse cosine) of a number and returns the angle in radians within the range 0 to π.

Acosh Calculates the inverse hyperbolic cosine of a number, accepting values greater than or equal to 1.

Acot Calculates the arccotangent (inverse cotangent) of a number and returns the principal value of the angle in radians.

Acoth Calculates the inverse hyperbolic cotangent of a number, requiring an absolute value greater than 1.

AmorDegrc 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.

AmorLinc Calculates linear depreciation for each accounting period using the French accounting system and returns the depreciated amount prorated for partial periods.

And Implements the AND function, which evaluates multiple conditions and returns TRUE only if all arguments are TRUE.

ArgumentConversionRules 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.

ArgumentInfo 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.

Asin Calculates the arcsine (inverse sine) of a number and returns the angle in radians within the range -π/2 to π/2.

Asinh Calculates the inverse hyperbolic sine of a number, accepting any real value.

Atan Calculates the arctangent (inverse tangent) of a number and returns the angle in radians within the range -π/2 to π/2.

Atan2 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 π.

Atanh Implements the ATANH function, which calculates the inverse hyperbolic tangent of a number.

Average Implements the AVERAGE function, which calculates the arithmetic mean of numeric arguments.

AverageA Implements the AVERAGEA function, which calculates the arithmetic mean including text and logical values converted to numbers.

BesselI Implements the BESSELI function, computing the modified Bessel function In(x) for purely imaginary arguments.

BesselJ Implements the BESSELJ function, computing the Bessel function Jn(x) of the first kind.

BesselK Implements the BESSELK function, computing the modified Bessel function Kn(x) of the second kind for purely imaginary arguments.

BesselY Implements the BESSELY function, computing the Bessel function Yn(x) of the second kind, also known as the Weber or Neumann function.

Bin2Dec Implements the BIN2DEC function, converting a binary string up to 10 bits into its decimal integer equivalent.

Bin2Hex Implements the BIN2HEX function, converting a binary string up to 10 bits into its hexadecimal string representation.

Bin2Oct Implements the BIN2OCT function, converting a binary string up to 10 bits into its octal string representation.

BitAnd Implements the BITAND function, performing a bitwise AND operation on two integers in the range 0 to 2⁴⁸−1.

BitLShift Implements the BITLSHIFT function, shifting an integer left by a specified number of bits up to ±53 positions.

BitOr Implements the BITOR function, performing a bitwise OR operation on two integers in the range 0 to 2⁴⁸−1.

BitRShift Implements the BITRSHIFT function, shifting an integer right by a specified number of bits up to ±53 positions.

BitXor Implements the BITXOR function, performing a bitwise exclusive OR operation on two integers in the range 0 to 2⁴⁸−1.

BooleansInFunction Abstract base for functions that accept boolean arguments, applying boolean-specific conversion rules during evaluation.

Ceiling Implements the CEILING function, which rounds a number up to the nearest multiple of a specified significance.

CeilingMath 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.

CeilingPrecise Implements the CEILING.PRECISE function, which rounds a number up to the nearest integer or multiple of significance regardless of sign.

CharFunction Implements the CHAR function, which converts a numeric code (1-255) to its corresponding character.

Code Implements the CODE function, which returns the numeric code of the first character in a text string.

Combin Implements the COMBIN function, which calculates the number of combinations for selecting items from a set without regard to order.

Complex Implements the COMPLEX function, constructing a complex number string in the form x + yi or x + yj from real and imaginary coefficients.

Concat Implements the CONCAT function, which combines multiple text strings and ranges into a single concatenated string.

Concatenate Implements the CONCATENATE function, which joins multiple text strings into a single combined string.

Convert 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.

Cos Implements the COS function, which calculates the cosine of an angle specified in radians.

Cosh Implements the COSH function, which calculates the hyperbolic cosine of a number.

Cot Implements the COT function, which calculates the cotangent of an angle specified in radians.

Coth Implements the COTH function, which calculates the hyperbolic cotangent of a number.

CountIf Implements the COUNTIF function, which counts cells in a range that meet a specified criteria.

CoupDayBs Calculates the number of days from the coupon period start to the settlement date and returns the day count for interest accrual calculations.

CoupDays Calculates the total number of days in the coupon period containing the settlement date and returns the period length for yield calculations.

CoupDaysNc Calculates the number of days from the settlement date to the next coupon date and returns the day count for interest period calculations.

CoupNcd Calculates the next coupon date after the settlement date and returns it as a serial date number for scheduling and valuation.

CoupNum Calculates the number of coupons payable between settlement and maturity and returns the count rounded up to the nearest whole coupon for payment scheduling.

CoupPcd Calculates the previous coupon date before the settlement date and returns it as a serial date number for accrued interest calculations.

Csc Implements the CSC function, which calculates the cosecant of an angle specified in radians.

Csch Implements the CSCH function, which calculates the hyperbolic cosecant of an angle in radians.

CumIPmt Calculates cumulative interest paid on a loan between specified periods and returns the total interest amount for the period range.

CumPrinc Calculates cumulative principal paid on a loan between specified periods and returns the total principal amount for the period range.

Date Implements the DATE function that constructs a date serial number from year, month, and day components, returning a formatted date value.

DateValue Implements the DATEVALUE function that parses a text string into a date serial number, allowing conversion of date strings to numeric values.

Day Implements the DAY function that extracts the day component (1-31) from a date serial number.

Days Implements the DAYS function that calculates the number of days between two dates by subtracting start date from end date.

Db Calculates depreciation for a specified period using the fixed-declining balance method and returns the depreciation amount for that period.

Dec2Bin Converts a decimal integer to its binary representation, optionally padding to a specified number of characters, with support for signed 10-bit values.

Dec2Hex Converts a decimal integer to its hexadecimal representation, optionally padding to a specified number of characters, with support for signed 40-bit values.

Dec2Oct Converts a decimal integer to its octal representation, optionally padding to a specified number of characters, with support for signed 30-bit values.

Degrees Implements the DEGREES function, which converts radians to degrees.

Delta 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.

Disc Calculates the discount rate for a security and returns the annual rate as a decimal value.

DollarDe Converts a dollar price from fractional notation to decimal notation and returns the decimal price value.

DollarFr Converts decimal dollar values to fractional dollar notation used in securities pricing.

Duration Calculates the Macauley duration of a security as the weighted average of present value cash flows, measuring bond price sensitivity to yield changes.

Effect Calculates the effective annual interest rate from a nominal rate and compounding frequency.

Erf Computes the error function integrated between two bounds, or from zero to a single bound, commonly used in statistics and probability calculations.

ErfC Computes the complementary error function integrated from a lower bound to infinity, providing the complement of the standard error function.

ErfCPrecise Computes the complementary error function integrated from a lower bound to infinity with precise calculation, providing the complement of the standard error function.

ErfPrecise Computes the error function integrated from zero to a specified upper bound with precise calculation, commonly used in statistics and probability calculations.

ErrorType Implements the ERROR.TYPE function, which maps error values to numeric codes (1-7) and returns #N/A if no error exists.

Even Implements the EVEN function, which rounds numbers up to the nearest even integer.

Exact Implements the EXACT function, which performs case-sensitive comparison of two text strings and returns TRUE if identical.

Exp Implements the EXP function, which raises Euler's number (e) to a specified power.

Fact Implements the FACT function, which calculates the factorial of a non-negative integer.

FactDouble Implements the FACTDOUBLE function, which calculates the double factorial of a number (product of every other integer).

False Implements the FALSE function, which returns the boolean value FALSE.

Find Implements the FIND function, which locates one text string within another and returns the starting position (case-sensitive).

Floor Implements the FLOOR function, which rounds a number down toward zero to the nearest multiple of significance.

FloorMath Implements the FLOOR.MATH function, which rounds a number down to the nearest integer or multiple with optional mode control for negative values.

FloorPrecise Implements the FLOOR.PRECISE function, which rounds a number down to the nearest multiple regardless of sign.

FunctionBase Abstract base for all spreadsheet functions, defining evaluation logic, argument rules, and metadata for use in formula expressions.

FunctionEvaluationContext<T> Encapsulates the context for function evaluation, including arguments, worksheet reference, and cell position where the function is invoked.

FunctionInfo Metadata describing a spreadsheet function's signature, including name, category, argument definitions, and result format.

FunctionManager Central registry for managing spreadsheet functions, enabling registration, unregistration, and lookup of built-in and custom functions by name.

FunctionWithArguments Base class for spreadsheet functions that accept arguments, handling argument conversion, validation, and typed evaluation.

FunctionWithSameTypeArguments<T> Base class for functions requiring all arguments to be of the same type, automatically converting object arguments to the specified type.

Fv Calculates the future value of an investment with periodic constant payments and a constant interest rate.

Gcd Implements the GCD function, which finds the greatest common divisor of two or more integers.

GEStep 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.

Hex2Bin Converts a hexadecimal number to binary representation, optionally padded to a specified length.

Hex2Dec Converts a hexadecimal number to decimal representation.

Hex2Oct Converts a hexadecimal number to octal representation, optionally padded to a specified length.

HLookup 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.

Hour Implements the HOUR function that extracts the hour component (0-23) from a time serial number.

HyperlinkFunction Implements the HYPERLINK function, which creates a clickable hyperlink to a document, web page, or email address and displays optional friendly text.

IfFunction Implements the IF function, which evaluates a logical condition and returns one value when TRUE and another when FALSE.

ImAbs Computes the absolute value (modulus) of a complex number provided in x+yi or x+yj text format.

Imaginary Extracts the imaginary coefficient from a complex number provided in x+yi or x+yj text format.

ImArgument Computes the argument θ (theta) of a complex number, expressed as an angle in radians.

ImConjugate Computes the complex conjugate of a complex number provided in x+yi or x+yj text format.

ImCos Computes the cosine of a complex number provided in x+yi or x+yj text format.

ImCosh Computes the hyperbolic cosine of a complex number provided in x+yi or x+yj text format.

ImCot Computes the cotangent of a complex number provided in x+yi or x+yj text format.

ImCsc Computes the cosecant of a complex number provided in x+yi or x+yj text format.

ImCsch Computes the hyperbolic cosecant of a complex number provided in x+yi or x+yj text format.

ImDiv Divides two complex numbers and returns the quotient in x+yi or x+yj text format.

ImExp Computes the exponential of a complex number provided in x+yi or x+yj text format.

ImLn Computes the natural logarithm of a complex number provided in x+yi or x+yj text format.

ImLog10 Computes the base-10 logarithm of a complex number in x+yi or x+yj text format.

ImLog2 Computes the base-2 logarithm of a complex number in x+yi or x+yj text format.

ImPower Raises a complex number in x+yi or x+yj text format to a specified power.

ImProduct Multiplies 1 to 255 complex numbers in x+yi or x+yj text format and returns their product.

ImReal Extracts the real coefficient from a complex number in x+yi or x+yj text format.

ImSec Computes the secant of a complex number in x+yi or x+yj text format.

ImSech Computes the hyperbolic secant of a complex number in x+yi or x+yj text format.

ImSin Computes the sine of a complex number in x+yi or x+yj text format.

ImSinh Computes the hyperbolic sine of a complex number in x+yi or x+yj text format.

ImSqrt Computes the square root of a complex number in x+yi or x+yj text format.

ImSub Subtracts one complex number from another in x+yi or x+yj text format and returns the difference.

ImSum Adds 1 to 255 complex numbers in x+yi or x+yj text format and returns their sum.

ImTan Computes the tangent of a complex number in x+yi or x+yj text format.

Index 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.

Indirect Implements the INDIRECT function, which evaluates a text string as a cell reference and returns the reference to that cell or range.

Int Implements the INT function, which rounds a number down to the nearest integer by removing the fractional part.

IntRate Calculates the interest rate for a fully invested security based on settlement, maturity, investment, and redemption values.

Ipmt Calculates the interest portion of a payment for a specific period in an investment with periodic constant payments and a constant interest rate.

IsBlank Tests whether a cell reference is empty and returns TRUE for blank cells, FALSE otherwise.

IsErr Tests whether a value is any error except #N/A and returns TRUE for errors other than #N/A, FALSE otherwise.

IsError Tests whether a value is any error and returns TRUE for any error value including #N/A, FALSE otherwise.

IsEven Tests whether a number is even and returns TRUE for even numbers, FALSE for odd numbers.

IsFormula Tests whether a cell reference contains a formula and returns TRUE for formula cells, FALSE otherwise.

IsLogical Tests whether a value is a boolean (TRUE or FALSE) and returns TRUE for logical values, FALSE otherwise.

IsNA Tests whether a value is the #N/A error and returns TRUE for #N/A errors, FALSE otherwise.

IsNonText Tests whether a value is not text and returns TRUE for non-text values, FALSE for text.

IsNumber Tests whether a value is a number and returns TRUE for numeric values, FALSE otherwise.

IsoCeiling 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.

IsOdd Tests whether a number is odd and returns TRUE for odd numbers, FALSE for even numbers.

Ispmt Calculates the interest paid during a specific period of an investment using straight-line amortization, provided for Lotus 1-2-3 compatibility.

IsRef Implements the ISREF function, which tests whether a value is a cell reference and returns TRUE for references or FALSE otherwise.

IsText Implements the ISTEXT function, which tests whether a value is text and returns TRUE for text values or FALSE otherwise.

Lcm Implements the LCM function, which calculates the least common multiple of integers—the smallest positive integer divisible by all provided values.

Left Implements the LEFT function, which extracts a specified number of characters from the beginning of a text string.

Len Implements the LEN function, which counts the total number of characters in a text string including spaces.

Ln Implements the LN function, which calculates the natural logarithm (base e) of a positive number.

Log 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.

Log10 Implements the LOG10 function, which calculates the base-10 logarithm of a positive number.

Lookup 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.

LookupFunctionBase Abstract base for table lookup functions such as VLOOKUP, HLOOKUP, and LOOKUP, providing shared logic for searching and matching values in ranges.

Lower Implements the LOWER function, which converts all uppercase letters in a text string to lowercase.

Max Implements the MAX function, which finds the largest numeric value among the arguments.

MaxA Implements the MAXA function, which finds the largest value among arguments including text and logical values converted to numbers.

MDuration Calculates the modified Macauley duration of a security, which adjusts duration for yield changes and measures interest rate sensitivity at $100 par value.

Median Implements the MEDIAN function, which calculates the middle value in a sorted set of numbers.

Mid Extracts a substring from text at a specified position and length; implements the MID text function.

Min Implements the MIN function, which finds the smallest numeric value among the arguments.

MinA Implements the MINA function, which finds the smallest value among arguments including text and logical values converted to numbers.

Minute Implements the MINUTE function, extracting the minute component from a time serial number and returning an integer 0–59.

Mod 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.

Mode Implements the MODE function, which finds the most frequently occurring value in a dataset.

Month Implements the MONTH function, extracting the month component from a date serial number and returning an integer 1–12.

MRound 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.

Multinomial Implements the MULTINOMIAL function, which calculates the ratio of the factorial of a sum of values to the product of their individual factorials.

N Implements the N function, which converts a value to a number, returning numeric values directly and 0 for other types.

NA Implements the NA function, which returns the #N/A error value to indicate missing or unavailable data.

Nominal Calculates the nominal annual interest rate from an effective rate and compounding frequency.

Not Implements the NOT function, which reverses the boolean value of its argument, returning FALSE for TRUE and TRUE for FALSE.

NPer Calculates the number of payment periods for an investment with periodic constant payments and a constant interest rate.

Npv Calculates the net present value of an investment using a discount rate and a series of future cash flows.

NumbersInFunction Base class for functions that accept numeric (double) arguments with automatic conversion rules.

Oct2Bin Converts an octal number to binary with optional zero-padding.

Oct2Dec Converts an octal number to its decimal representation.

Oct2Hex 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.

Odd Implements the ODD function, which rounds positive numbers up and negative numbers down to the nearest odd integer.

OddFPrice Calculates the price per $100 face value of a security with an odd (short or long) first coupon period.

OddFYield Calculates the yield of a security with an odd (short or long) first coupon period.

OddLPrice Calculates the price per $100 face value of a security with an odd (short or long) last coupon period.

OddLYield Calculates the yield of a security with an odd (short or long) last coupon period.

Or Implements the OR function, which evaluates multiple conditions and returns TRUE if any argument is TRUE.

PDuration Calculates the number of periods required for an investment to reach a target future value at a constant interest rate.

Pi Returns the mathematical constant Pi (approximately 3.14159265358979), accurate to 15 digits, for use in trigonometric and geometric calculations.

Pmt Calculates the periodic payment for a loan or annuity with constant payments and a constant interest rate.

Power Raises a number to a specified power and returns the result, supporting both integer and fractional exponents.

Ppmt Calculates the principal portion of a loan payment for a specific period with constant payments and a constant interest rate.

Price Calculates the price per $100 face value of a security that pays periodic interest.

PriceDisc Calculates the price per $100 face value of a discounted security that does not pay periodic interest.

Product Multiplies all numeric arguments and returns the product, accepting up to 255 arguments including ranges.

Pv Implements the PV financial function that calculates the present value of an investment based on periodic payments and interest rate.

Quotient Divides one number by another and returns the integer portion of the result, discarding the remainder.

Radians Converts an angle from degrees to radians for use in trigonometric calculations.

Rate Implements the RATE financial function that calculates the interest rate per period for an annuity using iterative approximation.

Received Implements the RECEIVED financial function that calculates the amount received at maturity for a fully invested security.

Rept Repeats text a specified number of times; implements the REPT text function.

Right Extracts the last characters from text based on a specified count; implements the RIGHT text function.

Round Rounds a number to a specified number of decimal places using standard rounding rules (0.5 rounds up).

RoundDown Rounds a number down toward zero to a specified number of decimal places, truncating rather than rounding up.

RoundUp Rounds a number up away from zero to a specified number of decimal places, always rounding in the positive direction.

Rri Implements the RRI financial function that calculates the equivalent interest rate for investment growth over a specified period.

Search Locates text within another text string using case-insensitive matching and returns the starting position; implements the SEARCH text function.

Sec Calculates the secant of an angle specified in radians, returning 1/cos(angle).

Sech Calculates the hyperbolic secant of a number specified in radians, returning 1/cosh(angle).

Second Implements the SECOND function, extracting the second component from a time serial number and returning an integer 0–59.

Sign Determines the sign of a number and returns 1 for positive, -1 for negative, or 0 for zero.

Sin Calculates the sine of an angle specified in radians for trigonometric calculations.

Sinh Calculates the hyperbolic sine of a number for hyperbolic trigonometric calculations.

Sln Implements the SLN financial function that calculates straight-line depreciation of an asset for a single period.

Sqrt Calculates the square root of a positive number, returning an error for negative values.

SqrtPi Calculates the square root of a number multiplied by Pi, returning sqrt(number × π) for geometric calculations.

Stdev Implements the STDEV function, which calculates sample standard deviation to measure data dispersion from the mean.

StdevA Implements the STDEVA function, which calculates sample standard deviation including text and logical values in the dataset.

StdevP Implements the STDEVP function, which calculates population standard deviation treating arguments as the entire population.

StdevPA Implements the STDEVPA function, which calculates population standard deviation including text and logical values in the dataset.

StringsInFunction Base class for spreadsheet functions that accept string arguments and handle string-based calculations.

Sum Implements the SUM function, which adds all numeric values in the specified arguments.

SumIf Implements the SUMIF function, which sums values in a range that meet a specified criteria.

SumSq Implements the SUMSQ function, which calculates the sum of the squares of numeric arguments.

Syd Implements the SYD financial function that calculates sum-of-years' digits depreciation for a specific period, which accelerates depreciation in early asset life.

Tan Implements the TAN function, which calculates the tangent of an angle in radians.

Tanh Implements the TANH function, which calculates the hyperbolic tangent of a number.

TBillEq Implements the TBILLEQ financial function that calculates the bond-equivalent yield for a Treasury bill.

TBillPrice Implements the TBILLPRICE financial function that calculates the price per $100 face value for a Treasury bill.

TBillYield Implements the TBILLYIELD financial function that calculates the yield for a Treasury bill based on settlement, maturity, and price.

Time Implements the TIME function, constructing a time serial number from separate hour, minute, and second components.

TimeValue Implements the TIMEVALUE function, parsing text-formatted time strings into time serial numbers in the range 0–0.99999999.

Today Implements the TODAY function, returning the current date as a serial number without a time component.

Trim Removes extra spaces from text, leaving only single spaces between words; implements the TRIM text function.

True Implements the TRUE function, which returns the boolean constant TRUE without requiring any arguments.

Trunc Implements the TRUNC function, which truncates a number to a specified precision by removing fractional digits.

TypeFunction 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).

Upper Converts text to uppercase letters; implements the UPPER text function.

Vdb Implements the VDB financial function that calculates variable declining balance depreciation for any period, with optional switching to straight-line depreciation.

VLookup 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.

Xor Implements the XOR function, which returns TRUE when an odd number of logical arguments are TRUE and FALSE when an even number are TRUE.

Year Implements the YEAR function, extracting the year component from a date serial number and returning an integer 1900–9999.

Yield Implements the YIELD financial function, which calculates the annual yield for a security with periodic interest payments.

YieldDisc Implements the YIELDDISC financial function, which calculates the annual yield for a discounted security that does not pay periodic interest.

YieldMat Implements the YIELDMAT financial function, which calculates the annual yield for a security that pays interest at maturity.

Enums

ArgumentInterpretation Defines how a function argument value should be interpreted during evaluation: used as-is, treated as error, ignored, or converted to a default value.

ArgumentType Categorizes function arguments by their expected data type for validation and documentation purposes.

ArrayArgumentInterpretation Defines how array arguments should be interpreted: use the first element only, use all elements, or ignore all elements.

FunctionCategory Categorizes spreadsheet functions by domain (Financial, DateTime, MathTrig, Statistical, etc.) for organizational and discovery purposes.