L
leebean337
Hi there
I am trying to create a function that will grab random values from a
given distribution (lognormal and beta in particular). I am currently
using the following code for lognormal:
dblValue = Application.WorksheetFunction.LogInv(Rnd(), v1, v2)
where v1 is my mean and v2 is my standard deviation. But each time I
try to run it, I get the error "Unable to get the LogInv property of
the Worksheet Function class"
Any suggestions?
I am trying to create a function that will grab random values from a
given distribution (lognormal and beta in particular). I am currently
using the following code for lognormal:
dblValue = Application.WorksheetFunction.LogInv(Rnd(), v1, v2)
where v1 is my mean and v2 is my standard deviation. But each time I
try to run it, I get the error "Unable to get the LogInv property of
the Worksheet Function class"
Any suggestions?