ACOS function

This topic describes the formula syntax and usage of the ABS function in the Data Quality Execute Formula transform.

Description

Returns the arccosine, or inverse cosine, of a number. The arccosine is the angle whose cosine is number. The returned angle is given in radians in the range 0 (zero) to π

Tip: If you want to convert the result from radians to degrees, multiply it by 180/PI() or use the DEGREES function.

Syntax

ACOS(number)

The ACOS function syntax has the following argument.

  • number Required. The cosine of the angle you want. The value must be from -1 to 1.

Example

Data: -0.5 in Cosines field.
Formula Description Result
ACOS([Cosines]) Arccosine of -0.5 in radians 2.094395102
ACOS([Cosines])*180/PI() Arccosine of -0.5 in degrees 120
DEGREES(ACOS([Cosines])) Arccosine of -0.5 in degrees 120