ASIN function
Overview
ASIN is a function of the Math and Trigonometry category that calculates the inverse sine (arcsine) of a number in the range [-1 to +1], returning an angle in the range [-
Usage
Syntax
ASIN(number) => asin
Argument descriptions
- number (number, required). The number whose arcsine is to be calculated, in the range [-1 to +1].
Additional guidance
None.
Returned value
ASIN returns a number in radians in the range [-
Error conditions
- In common with many other IronCalc functions, ASIN propagates errors that are found in its argument.
- If no argument, or more than one argument, is supplied, then ASIN returns the
#ERROR!
error. - If the value of the number argument is not (or cannot be converted to) a number, then ASIN returns the
#VALUE!
error. - If the value of the number argument lies outside the range [-1 to +1], then ASIN returns the
#NUM!
error. - For some argument values, ASIN may return a
#DIV/0!
error. - For more information about the different types of errors that you may encounter when using IronCalc functions, visit our Error Types page.
Details
- The ASIN function utilizes the asin() method provided by the Rust Standard Library.
- The figure below illustrates the output of the ASIN function for angles
in the range -1 to +1 radians.
Examples
See some examples in IronCalc.
Links
- For more information about inverse trigonometric functions, visit Wikipedia's Inverse trigonometric functions page.
- See also IronCalc's SIN, COS and TAN functions.
- Visit Microsoft Excel's ASIN function page.
- Both Google Sheets and LibreOffice Calc provide versions of the ASIN function.