Steve Hebert’s .Math Library

Sponsored by Hebert Software Services, LLC

Operator and Function Documentation

 

 

 

Binary Operators

Operator

Description

=

Returns 1 if both sides are equal.

Returns 1 if left side is less than the right.

Returns 1 if left side is greater than the right.

<=

Returns 1 if the left side is less than or equal to the right.

>=

Returns 1 if the left side is greater than or equal to the right.

<> 

Returns 1 if the left side is not equal to the right.

&

Returns 1 if both sides are not equal to 0

|

Returns 1 if one or both sides are not equal to 1.

 

Built-in Functions

Function

Description

Abs

Absolute value of a specified value or expression.

Acos

Returns the angle whose cosine is the specified number.

Asin

Returns the angle whose sin is the specified number.

Atan

Returns the angle whose tangent is the specified number.

Ceiling

Returns the smallest whole number greater than or equal to the specified number.

Cos

Returns the cosine of the specified angle.

Cosh

Returns the hyperbolic cosine of the specified angle.

Exp

Returns e raised to the specified power.

Floor

Returns the largest whole number less than or equal to the specified number.

Log

Returns the logarithm of the specified number.

Log10

Returns the base 10 logarithm of the specified number.

Round

Returns the value nearest the specified value.

Sign

Returns a value indicating the sign of the specified value.

Sin

Returns the sine of the specified angle.

Sinh

Returns the hyperbolic sine of the specified angle.

Sqrt

Returns the square root of the specified number.

Tan

Returns the tangent of the specified angle.

Tanh

Returns the hyperbolic tangent of the specified angle.

Min

Min(expr1, expr2, […, expr(n)])  Min returns the minimum value among the list of evaluated expressions.  The list may contain 2 or more elements.  Highest current test uses 50,000 values in the expression list.

Max

Max(expr1, expr2, […, expr(n)])  Max returns the maximum value among the list of evaluated expressions.  The list may contain 2 or more elements.  Highest current test uses 50,000 values in the expression list.

If

If( binary_expression, true_expression, false_expression )  If the value of binary_expression is non-zero, the true_expression evaluation is returned. Otherwies the false_expression is returned.