Radians in UDF

[Rumpkin]

Hello,
Please review this formula to see why it does not work as a UDF.
It will work in the spreadsheet by either referencing cells that contain the degrees or by hard entering the degrees. Purpose is to find the cosine of the product of the cosine of two angels.

[TABLE="width: 80"]
<colgroup><col style="width:60pt" width="80"> </colgroup><tbody>[TR]
   [TD="width: 80"]Function TRUEBEND(SIDE_BEND, VERT_BEND)[/TD]
  [/TR]
  [TR]
   [TD]TRUEBEND = Application.WorksheetFunction.Round(Acos(Cos(Radians(SIDE_BEND)) * Cos(Radians(VERT_BEND))) / Radians(1), 2)[/TD]
  [/TR]
  [TR]
   [TD]End Function
[/TD]
  [/TR]
 </tbody>[/TABLE]

 

[StephenCrump]

Acos() and Radians() aren't VBA functions, but you can call the Excel functions from VBA.