Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

normal law/distribution in VBA

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • normal law/distribution in VBA

    Hi guys,

    How can I calculate a normal standard inverse value in VBA ?
    In the excel spreadsheet the function is NormSInv(x) but I don't manage to insert it directly in VBA ? This function is not defined in VBA.

    It is the same problem for severals other specific functions.

    thanks

  • #2
    Re: normal law/distribution in VBA

    Hi baladame and welcome,

    You can use the WorksheetFunction object.
    Code:
    MsgBox Application.WorksheetFunction.NormSInv(0.25)

    Cheers
    Andy

    Comment

    Trending

    Collapse

    There are no results that meet this criteria.

    Working...
    X