A to Z of Excel Functions: The CSC Function
23 February 2018
Welcome back to our regular A to Z of Excel Functions blog. Today we look at the CSC function.
The CSC function
In trigonometry, given a right-angled triangle, the cosecant of an angle is the length of the hypotenuse divided by the length of the opposite side. It is effectively the reciprocal of the sine of the angle, viz.
It has the following chart properties:
The CSC function employs the following syntax to operate:
CSC(number)
The CSC function has the following arguments:
- number: this is required.
It should be further noted that:
- the absolute value of number must be less than 2^27
- if number is outside its constraints, CSC returns the #NUM! error value
- if number is a non-numeric value, CSC returns the #VALUE! error value
- CSC(n) equals 1/SIN(n).
Please see my example below:
We’ll continue our A to Z of Excel Functions soon. Keep checking back – there’s a new blog post every other business day.