Spreadsheet functions, Math & trig functions – Juniper Systems Allegro CX Manual User Manual
Page 147
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.
▲