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. |
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 floating-point number's cumulative exception flags and raises cumulative floating-point number's exceptions if RaisePending is True . |
ClearFPUExceptions | Clears all exception bits in the FPU status word. |
ClearSSEExceptions | Clears all exception bits in the SSE’s MXCSR register. |
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. |
DegNormalize | |
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. |
Floor | Rounds variables toward negative infinity. |
FMod | Returns the remainder of ANumerator / ADenominator (like mod in integers) with the same sign as ANumerator. |
Frexp | Separates the Mantissa and Exponent of X |
FutureValue | Calculates the future value of an investment. |
GetExceptionMask | Returns the current floating-point exception mask. |
GetExceptions | Retrieves the set of active floating-point exceptions. |
GetFPUExceptionMask | Returns the set of masked FPU floating-point arithmetic exceptions. |
GetFPURoundMode | Gets the Intel FPU's rounding mode. |
GetPrecisionMode | Returns the Intel FPU precision control mode. |
GetRoundMode | Returns the current floating-point rounding mode. |
GetSSEExceptionMask | Returns the set of masked Intel SSE arithmetic exceptions. |
GetSSERoundMode | Gets the Intel SSE's 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. |
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. |
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. |
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. |
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 Exponent power. |
PresentValue | Calculates the present value of an investment. |
RadToCycle | Converts radians to cycles. |
RadToDeg | Converts radians to degrees. |
RadToGrad | Converts radians to grads. |
RaiseExceptions | Raises cumulative floating-point number's exceptions. |
RandG | Generates random numbers with Gaussian distribution. |
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. |
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 for the floating-point exceptions. |
SetExceptions | Sets the floating-point exceptions specified in Exceptions . |
SetFPUExceptionMask | Sets the floating-point exception masks TFPUExceptionMask in the Intel FPU control word. |
SetFPURoundMode | Sets the Intel X87 FPU's rounding mode. |
SetPrecisionMode | Sets the Intel FPU precision control mode. |
SetRoundMode | Sets the rounding mode for floating-point calculations. |
SetSSEExceptionMask | Sets the floating-point exception masks TSSEExceptionMask in the Intel SSE’s MXCSR register. |
SetSSERoundMode | Sets the Intel SSE's rounding mode. |
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 symmetric 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. |