VBA to simulate poisson distribution

**Ztv** · 09-18-2014, 05:16 AM

Hi again

I have entered the following function:

Please Login or Register  to view this content.

And now I want to simulate x values from the possion distribution. So I've entered this code:

Please Login or Register  to view this content.

But all cells returns #NAME? - why?

Hope that some of you can help me - maybe tell me, in short, what I'm missing about the syntax?

**Richard Buttrey** · 09-18-2014, 05:20 AM

Hi,

There seem to be typos with lambda/lamdda and ranpoi/randoi

**Ztv** · 09-18-2014, 05:53 AM

Sorry! I have corrected it now:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

EDITED: I forgot a typo

corrected now. Sorry

Re: VBA to simulate poisson distribution