SEC function - Zoho Sheet - Help Guide

SEC

Returns the secant of the given angle, in radians.
 
Syntax
 
SEC(angle)
angle - The angle in radians that you want to calculate the secant of. Eg., 0.3

Remarks
  • If the input angle is in degrees, multiply it by PI()/180 to get the value in radians.
  • The input value must be less than 2^27.
 
Examples
 
Formula
Result
=SEC(0.3)
1.046751602
=SEC(-0.9)
1.60872581
=SEC(30)
6.482921235

Get a hands-on experience of the function in the embedded range below.



Possible Errors
 
Errors
Meaning
#N/A!
  • The function could not find the value it was asked to look for. Commonly occurs in VLOOKUP and similar functions.
#NAME!
  • The function name is incorrect or invalid.
  • The given defined name (if any) is invalid.
  • There is a typo in the defined name used in the function.
  • Double quotes are missing for text values in the function.
  • Colon missing in a cell range reference.
#VALUE!
  • The given argument's data type is incorrect or invalid.
    For example, the given input is not a numerical value.
#REF!
  • The given cell reference is incorrect or invalid. This error may occur when a cell/range has been deleted, moved, or pasted over.
#NUM!
  • The given value is greater than 2^27.
 
Similar Functions
  • ACOS
  • ACOSH
  • ACOT
  • ACOTH
  • ASIN
  • ASINH
  • ATAN
  • ATANH
  • ATAN2
  • COS
  • COSH
  • COT
  • COTH
  • CSC
  • CSCH
  • DEGREES
  • PI
  • RADIANS
  • SECH
  • SINH
  • TAN
  • TANH