CODEWITHSUNDEEP
excelvba
pouya
pouya

Reputation: 3776

Radians internal function not defined

why excel keeps telling me radians internal function is not defined

Here is the my function definition:

Public Function Ev(x As Double, length As Integer, beta As Double, curvature As Double) As Double
    Dim height As Double

    beta = Radians(beta)
    height = Round(length * Tan(beta), 0)
    Ev = height * (1 - (x / length)) ^ curvature

End Function

Err Screenshot

Upvotes: 2

Views: 4954

Answers (1)

chris neilsen
chris neilsen

Reputation: 53136

why excel keeps telling me radians internal function is not defined?

Because it doesn't exist!

Use WorksheetFunction instead:

beta = Application.WorksheetFunction.Radians(beta)

Upvotes: 3

Related Questions