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 |