Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 2 of 2

Thread: normal law/distribution in VBA

  1. #1
    Join Date
    9th November 2004
    Posts
    3

    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

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,313

    Re: normal law/distribution in VBA

    Hi baladame and welcome,

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

    Cheers
    Andy


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Random Number Within Normal Distribution
    By J88L in forum EXCEL HELP
    Replies: 3
    Last Post: November 28th, 2007, 07:21
  2. Is Random Normal Distribution Possible
    By ferreira in forum EXCEL HELP
    Replies: 3
    Last Post: July 18th, 2007, 14:58
  3. Normal Distribution Graph
    By Tactician in forum EXCEL HELP
    Replies: 5
    Last Post: November 16th, 2006, 07:40
  4. Random Number with normal distribution
    By pdsasse in forum EXCEL HELP
    Replies: 6
    Last Post: July 20th, 2006, 22:10
  5. Test for Normal Distribution
    By tja26 in forum EXCEL HELP
    Replies: 5
    Last Post: January 19th, 2006, 01:07

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno