Excel functions / Math
SEC function
The secant of an angle: 1 divided by its cosine.
Syntax
=SEC(number)
Arguments
number: The angle, in radians. Wrap degrees in RADIANS().
When to use it
SEC gives the secant of an angle in radians: 1 divided by its cosine.
Examples
The secant of 60 degrees
A B C 1 Degrees 2 60 2 In C2:
=SEC(RADIANS(A2))→ 2
Common mistakes
- Degrees. Excel works in radians. Wrap an angle in degrees in RADIANS, and a result in DEGREES to read it in degrees.
SEC in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: SEC
- Danish: SEC
- Dutch: SEC
- Finnish: SEK
- French: SEC
- German: SEC
- Hungarian: SEC
- Italian: SEC
- Norwegian: SEC
- Polish: SEC
- Portuguese (Brazil): SEC
- Portuguese (Portugal): SEC
- Russian: SEC
- Spanish: SEC
- Swedish: SEK
- Turkish: SEC