beautypg.com

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

Page 147

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.