Functions

The following table lists functions in this documentation.

	Name	Description
	ArcCos	Calculates the inverse cosine of a given number.
	ArcCos	Calculates the inverse cosine of a given number.
	ArcCos	Calculates the inverse cosine of a given number.
	ArcCosh	Calculates the inverse hyperbolic cosine of a given number.
	ArcCot	Calculates the inverse cotangent of a given number.
	ArcCotH	Calculates the inverse hyperbolic cotangent of a given number.
	ArcCsc	Calculates the inverse cosecant of a given number.
	ArcCscH	Calculates the inverse hyperbolic cosecant of a given number.
	ArcSec	Calculates the inverse secant of a given number.
	ArcSecH	Calculates the inverse hyperbolic secant of a given number.
	ArcSin	Calculates the inverse sine of a given number.
	ArcSin	Calculates the inverse sine of a given number.
	ArcSin	Calculates the inverse sine of a given number.
	ArcSinh	Calculates the inverse hyperbolic sine of a given number.
	ArcTan2	Calculates the arctangent angle and quadrant of a given number.
	ArcTanh	Calculates the inverse hyperbolic tangent of a given number.
	Ceil	Rounds variables up toward positive infinity.
	ClearExceptions	Clears exception bits in FPU status word.
	CompareValue	Returns the relationship between two numeric values.
	CompareValue	Returns the relationship between two numeric values.
	CompareValue	Returns the relationship between two numeric values.
	CompareValue	Returns the relationship between two numeric values.
	CompareValue	Returns the relationship between two numeric values.
	Cosecant	Returns the cosecant of an angle.
	Cosh	Calculates the hyperbolic cosine of an angle.
	Cot	Calculates the cotangent of an angle.
	Cotan	Calculates the cotangent of an angle.
	CotH	Calculates the hyperbolic cotangent of an angle.
	Csc	Returns the cosecant of an angle.
	CscH	Returns the hyperbolic cosecant of an angle.
	CycleToDeg	Converts an angle measurement from cycles to degrees.
	CycleToGrad	Converts an angle measurement from cycles to grads.
	CycleToRad	Converts an angle measurement from cycles to radians.
	DegToCycle	Returns the value of a degree measurement expressed in cycles.
	DegToGrad	Returns the value of a degree measurement expressed in grads.
	DegToRad	Returns the value of a degree measurement expressed in radians.
	DivMod	Returns the result of an integer division, including the remainder.
	DoubleDecliningBalance	Calculates the depreciation of an asset using the double-declining balance method.
	EnsureRange	Returns the closest value to a specified value within a specified range.
	EnsureRange	Returns the closest value to a specified value within a specified range.
	EnsureRange	Returns the closest value to a specified value within a specified range.
	Floor	Rounds variables toward negative infinity.
	Frexp	Separates the Mantissa and Exponent of X
	FutureValue	Calculates the future value of an investment.
	GetExceptionMask	Returns the exception mask from the FPU control word.
	GetPrecisionMode	Returns the FPU precision control mode.
	GetRoundMode	Returns the FPU rounding mode.
	GradToCycle	Converts grad measurements to cycles.
	GradToDeg	Converts grad measurements to degrees.
	GradToRad	Converts grad measurements to radians.
	Hypot	Calculates the length of the hypotenuse.
	IfThen	Conditionally returns one of two specified values.
	IfThen	Conditionally returns one of two specified values.
	IfThen	Conditionally returns one of two specified values.
	InRange	Indicates whether a value falls within a specified range.
	InRange	Indicates whether a value falls within a specified range.
	InRange	Indicates whether a value falls within a specified range.
	InterestPayment	Calculates the interest portion of a loan payment.
	InterestRate	Returns the interest rate required to increase PresentValue to FutureValue.
	InternalRateOfReturn	Calculates the internal rate of return for an investment.
	IntPower	Calculates the integral power of a base value.
	IsInfinite	Indicates when a variable or expression represents an infinite value.
	IsNan	Indicates when a variable or expression does not evaluate to a numeric value.
	IsNan	Indicates when a variable or expression does not evaluate to a numeric value.
	IsNan	Indicates when a variable or expression does not evaluate to a numeric value.
	IsZero	Indicates when a floating-point variable or expression evaluates to zero, or very close to zero.
	IsZero	Indicates when a floating-point variable or expression evaluates to zero, or very close to zero.
	IsZero	Indicates when a floating-point variable or expression evaluates to zero, or very close to zero.
	Ldexp	Calculates X times (2 to the power of P).
	LnXP1	Returns the natural log of (X+1)
	Log10	Calculates log base 10.
	Log2	Calculates log base 2.
	LogN	Calculates the log of X for a specified base.
	Max	Returns the greater of two numeric values (Delphi only).
	Max	Returns the greater of two numeric values (Delphi only).
	Max	Returns the greater of two numeric values (Delphi only).
	Max	Returns the greater of two numeric values (Delphi only).
	Max	Returns the greater of two numeric values (Delphi only).
	MaxIntValue	Returns the largest signed value in an integer array.
	MaxValue	Returns the largest signed value in an array.
	Mean	Returns the average of all values in an array.
	MeanAndStdDev	Calculates the mean and standard deviation of array elements.
	Min	Returns the lesser of two numeric values (Delphi only).
	Min	Returns the lesser of two numeric values (Delphi only).
	Min	Returns the lesser of two numeric values (Delphi only).
	Min	Returns the lesser of two numeric values (Delphi only).
	Min	Returns the lesser of two numeric values (Delphi only).
	MinIntValue	Returns the smallest signed value in an integer array.
	MinValue	Returns smallest signed value in an array.
	MomentSkewKurtosis	Calculates the mean, variance, skew, and kurtosis.
	NetPresentValue	Calculates the current value from an array of estimated cash flow values.
	Norm	Returns the Euclidean 'L-2' norm.
	NumberOfPeriods	Returns the number of payment periods for an investment.
	Payment	Calculates a fully amortized payment.
	PeriodPayment	Returns the principal amount from a full payment.
	Poly	Evaluates a uniform polynomial of one variable at the value X.
	PopnStdDev	Calculates the population standard deviation.
	PopnVariance	Calculates the population variance.
	Power	Raises Base to any power.
	Power	Raises Base to any power.
	Power	Raises Base to any power.
	PresentValue	Calculates the present value of an investment.
	RadToCycle	Converts radians to cycles.
	RadToDeg	Converts radians to degrees.
	RadToGrad	Converts radians to grads.
	RandG	Generates random numbers with Gaussian distribution.
	RandomFrom	Returns a randomly selected element from an array.
	RandomFrom	Returns a randomly selected element from an array.
	RandomFrom	Returns a randomly selected element from an array.
	RandomRange	Returns a random integer from a specified range.
	RoundTo	Rounds a floating-point value to a specified digit or power of ten using "Banker's rounding".
	SameValue	Indicates whether two floating-point values are (approximately) equal.
	SameValue	Indicates whether two floating-point values are (approximately) equal.
	SameValue	Indicates whether two floating-point values are (approximately) equal.
	Sec	Calculates the secant of an angle.
	Secant	Calculates the secant of an angle.
	SecH	Calculates the hyperbolic secant of an angle.
	SetExceptionMask	Sets the exception mask on the FPU control word.
	SetPrecisionMode	Sets the FPU precision control mode.
	SetRoundMode	Sets the FPU rounding mode.
	Sign	Indicates whether a numeric value is positive, negative, or zero.
	Sign	Indicates whether a numeric value is positive, negative, or zero.
	Sign	Indicates whether a numeric value is positive, negative, or zero.
	SimpleRoundTo	Rounds a floating-point value to a specified digit or power of ten using asymmetric arithmetic rounding.
	SinCos	Returns sine and cosine of an angle.
	Sinh	Returns the hyperbolic sine of an angle.
	SLNDepreciation	Returns the straight-line depreciation allowance of an asset.
	StdDev	Returns the sample standard deviation for elements in an array.
	Sum	Returns the sum of the elements in an array.
	SumInt	Returns the sum of the elements in an integer array.
	SumOfSquares	Returns the sum of the squared values from a data array.
	SumsAndSquares	Returns the sum of the values and the sum of the squared values in an array.
	SYDDepreciation	Calculates depreciation for an asset.
	Tan	Returns the tangent of X.
	Tanh	Returns the hyperbolic tangent of X.
	TotalVariance	Returns the statistical variance from an array of values.
	Variance	Calculates statistical sample variance from an array of data.

What do you think about this topic? Send feedback!