Documentation/Calc Functions/SEC

From The Document Foundation Wiki
Jump to navigation Jump to search
Other languages:
English • ‎dansk



Function name:

SEC

Category:

Mathematical

Summary:

Returns the secant of the given angle (in radians).

Syntax:

SEC(Number)

Returns:

Returns the (trigonometric) secant of Number, the angle in radians.

Arguments:

Number is a real number or reference to the cell containing that number whose secant value is to be calculated.

Additional details:

  • Mathematically, secant of odd multiples of π/2, i.e. {......-3π/2,-π/2,+π/2,+3π/2.....} is undefined but the PI() function uses an approximate value of π hence the function doesn't return any error value.
  • To insert an angle in degrees, either multiply the angle by PI()/180 or use the RADIANS function to convert the angle to radians.
  • The formula for the SEC function is:
Sece.png

Where N is the Number

The figure below illustrates the function SEC.

SEC function

Examples:

Formula Description Returns
=SEC(PI()/4) secant or inverse cosine of PI/4 or π/4 radians 1.4142135623731
=SEC(1) secant or inverse cosine of 1 radian 1.85081571768093
=SEC(RADIANS(60)) secant of 60° by first converting angle in degrees to radians 2
=SEC(PI()/2) secant of PI/2 or π/2 radians, since PI value is approaximate the function doesn't return any error rather gives an extremely large value 1.63312393531954E+016

Related LibreOffice functions:

SECH

COS

RADIANS

ODF standard:

Section 6.16.52, part 2.

Equivalent Excel functions:

SEC