Skip to content

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 [-π/2 to +π/2], expressed in radians.

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 [-π/2 to +π/2] that is the angle whose sine is the specified number.

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 x in the range -1 to +1 radians.

Examples

See some examples in IronCalc.