ArcCosine Trig Function (1 Viewer)

[Colin]

Is there a function for Arc-Cosine? I see the standard Sin & Cos, and know that VisualBasic has one (I'm trying to compute the distance between two postal codes for a LookUp function)

 

[Richie]

Found this if it's any help
Function ArcCos(x As Double) As Double
' Inverse Cosine
If x = 1 Then
ArcCos = 0
ElseIf x = -1 Then
ArcCos = -PI()
Else
ArcCos = Atn(x / Sqr(-x * x + 1)) + PI() / 2
End If
End Function

 

[Colin]

Actually, that is perfect. I forgot that the ArcCosine can be expressed in terms of the ArcTangent. Thank you