MATH

Functions and macros of the MATH add-in.

This add-in calls functions declared in the header.

Category MATH

MATH.ABS Calculates the absolute value of the argument.
MATH.ACOS Calculates the arccosine.
MATH.ACOSH Calculates the inverse hyperbolic cosine.
MATH.ASIN Calculates the arcsine.
MATH.ASINH Calculates the inverse hyperbolic sine.
MATH.ATAN Calculates the arctangent of x (atan, atanf, and atanl) or the arctangent of y/x (atan2, atan2f, and atan2l).
MATH.ATANH Calculates the inverse hyperbolic tangent.
MATH.CBRT Calculates the cube root.
MATH.CEIL Calculates the ceiling of a value.
MATH.COPYSIGN Returns a value that has the magnitude of one argument and the sign of another.
MATH.COS Calculates the cosine.
MATH.COSH Calculates the hyperbolic cosine.
MATH.ERF Computes the error function or the complementary error function of a value.
MATH.EXP Calculates the exponential.
MATH.EXP2 Computes 2 raised to the specified value.
MATH.EXPM1 Computes the base-e exponential of a value, minus one.
MATH.FABS Calculates the absolute value of the floating-point argument.
MATH.FDIM Determines the positive difference between the first and second values.
MATH.FLOOR Calculates the floor of a value.
MATH.FMA Multiplies two values together, adds a third value, and then rounds the result, without losing any precision due to intermediary rounding.
MATH.FMAX Determine the larger of two specified numeric values.
MATH.FMIN Determines the smaller of the two specified values.
MATH.FMOD Calculates the floating-point remainder.
MATH.FREXP Gets the mantissa and exponent of a floating-point number.
MATH.HYPOT Calculates the hypotenuse.
MATH.ILOGB Retrieves an integer that represents the unbiased base-2 exponent of the specified value.
MATH.LDEXP Multiplies a floating-point number by an integral power of two.
MATH.LGAMMA Determines the natural logarithm of the absolute value of the gamma function of the specified value.
MATH.LOG Calculates logarithms.
MATH.LOG1P Computes the natural logarithm of 1 plus the specified value.
MATH.LOG2 Determines the binary (base-2) logarithm of the specified value.
MATH.LOGB Extracts the exponent value of a floating-point argument.
MATH.MODF Splits a floating-point value into fractional and integer parts.
MATH.NAN Returns a quiet NaN value.
MATH.NEARBYINT Rounds the specified floating-point value to an integer, and returns that value in a floating-point format.
MATH.NEXTAFTER Returns the next representable floating-point value.
MATH.POW Calculates x raised to the power of y.
MATH.REMAINDER Computes the remainder of the quotient of two floating-point values, rounded to the nearest integral value.
MATH.REMQUO Computes the remainder of two integer values, and stores an integer value with the sign and approximate magnitude of the quotient in a location that's specified in a parameter.
MATH.RINT Rounds a floating-point value to the nearest integer in floating-point format.
MATH.ROUND Rounds a floating-point value to the nearest integer value.
MATH.SCALBN Multiplies a floating-point number by an integral power of FLT_RADIX.
MATH.SIN Calculates the sine of a floating-point value.
MATH.SINH Calculates the hyperbolic sine.
MATH.SQRT Calculates the square root.
MATH.TAN Calculates the tangent.
MATH.TANH Calculates the hyperbolic tangent.
MATH.TGAMMA Determines the gamma function of the specified value.
MATH.TRUNC Determines the nearest integer that is less than or equal to the specified floating-point value.
MATH._CHGSIGN Reverses the sign of a floating-point argument.
MATH._FPCLASS Returns a value indicating the floating-point classification of the argument.
MATH._J0 Computes the Bessel function of the first or second kind, of orders 0, 1, or n. The Bessel functions are commonly used in the mathematics of electromagnetic wave theory.
MATH._ROTL Rotates bits to the left (_rotl) or right (_rotr).
MATH._SCALB Scales argument by a power of 2.

Category XLL

XLL.PASTE.BASIC Paste a function with default arguments. Shortcut Ctrl-Shift-B.
XLL.PASTE.CREATE Paste a function and create named ranges for arguments. Shortcut Ctrl-Shift-C