Excel like a finance pro.
← The libraryPractice · 2 questions →
Math function
SEC
Returns the secant of an angle given in radians.
Rarely usedDifficulty 1250 · ProficientUsage rank #288 of 520
When to use it
Secant of an angle in radians: 1/COS.
The shape of it
- Syntax
=SEC(number)
Worked examples
Zero
=SEC(0) → 1
Cosine is 1 at zero.
60 degrees
=SEC(RADIANS(60)) → 2
Cosine of 60° is 0.5.
One radian
=SEC(1) → 1.850815718
One radian.
Worth knowing
- Convert degrees first.
- Slant length from horizontal distance: distance*SEC(angle).
- No inverse function; use ACOS(1/x).
Where it goes wrong
- #DIV/0! at pi/2 and odd multiples.
- Large inputs return #NUM!.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.