ReferenceFunctionsMath Functions

ASIN

ASIN: Returns the angle in radians whose sine is the input value.

Summary

Use ASIN to recover an angle from a normalized ratio.

Remarks

Domain: input must be between -1 and 1, inclusive.
Radians: output is in the range [-PI()/2, PI()/2].
Errors: returns #NUM! when the input is outside the valid domain.

Examples

Arcsine of one half

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

0.5235987755982989

Lower boundary

Grid

Cell	Value
No inputs on Sheet1.

Formula

=

Result

Not evaluated yet.

Expected

-1.5707963267948966

FAQ

When does ASIN return #NUM!?

ASIN returns #NUM! when the input is outside the closed interval [-1, 1].

Runtime metadata

Category

Math

Signature

ASIN(arg1: Number)

Arity

min 1, max 1

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PUREELEMENTWISENUMERIC_ONLY

Source

crates/formualizer-eval/src/builtins/math/trig.rs

ARABIC

Converts a Roman numeral string to its Arabic numeric value.

ASINH

ASINH: Returns the inverse hyperbolic sine of a number.

On this page

Summary Remarks Examples Related functions FAQ When does ASIN return #NUM!?Runtime metadata