Spreadsheet functions, Math & trig functions – Juniper Systems Allegro CX Manual User Manual

Page 147

Advertising
background image

Allegro CX Owner’s Manual 147

Spreadsheet Functions

The following sections are the available spreadsheet functions
available in PTab.

Math & Trig Functions

Abs(number)

Returns the absolute value of a number.

Example: Abs(-3) equals 3.

Acos(number)

Returns the arccosine of a number. The number must be from -1 to 1.

Example: Acos(-0.5) equals 2.094395.

Acosh(number)

Returns the inverse hyperbolic cosine of a number. The number must
be greater or equal to 1.

Example: Acosh(1) equals 0.04613.

Asin(number)

Returns the arcsine of a number. The number must be from -1 to 1.

Example: Asin(-0.5) equals -0.5236.

Asinh(number)

Returns the inverse hyperbolic sine of a number.

Example: Asinh(8) equals 2.77647.

Atan(number)

Returns the arctangent of a number.

Example: Atan(0.5) equals 0.46365.

Atan2(x,y)

Returns the arctangent of the specifi ed x and y coordinates.

Example: Atan2(1, 1) equals 0.785398.

Atanh(number)

Returns the inverse hyperbolic tangent of a number. The number
must be between -1 and 1 (excluding -1 and 1).

Example: Atanh(-0.1) equals -0.10034.

Advertising