Trigonometric Functions

EasySpreadsheet includes the sine, cosine, and tangent functions. It is important to remember that trigonometric functions use input values in radians.

(The circumference of a circle is 2*pi*r. Thus for a unit circle, the circumference is 2*pi. If we measure angle by the length of the circular arc, then a 360 degree circle will contain 2*pi radians. )

 

Cosine, Sine, and Tangent Functions

COS (number): Returns the cosine of the specified angle (number). The angle is in radians.

SIN (number): Returns the sine of the specified angle (number). The angle is in radians.

TAN (number): Returns the tangent of the specified angle (number). The angle is in radians.

 

Inverse Functions

ACOS (number): Returns the angle whose cosine is the specified number. This angle is given in radians, between zero and pi.

ASIN (number): Returns the angle whose sine is the specified number. This angle is given in radians, between -pi/2 and pi/2.

ATAN (number): Returns the angle whose tangent is the specified number. This angle is given in radians, between -pi/2 and pi/2.

ATAN2 (number1, number2): Returns the arctangent of the specified X (number1) and Y (number2) coordinates. The result will be given in radians, between -pi and pi, excluding -pi.

 

Hyperbolic Functions

COSH (number): Returns the hyperbolic cosine of the number.

SINH (number): Returns the hyperbolic sine of the number.

TANH (number): Returns the hyperbolic tangent of the number.

ACOSH (number): Returns the inverse hyperbolic cosine of the number.

ASINH (number): Returns the inverse hyperbolic sine of the number.

ATANH (number): Returns the inverse hyperbolic tangent of a the number.

 

Conversion and Constant Functions

DEGREES (number): Converts the number from radians to degrees.

PI (): Returns the value of pi, which is approximately 3.1459265358979 when calculated to 15 significant digits.