Polynomial approximation

[BJBenton]

I am trying to put together a spreadsheet to calculate the pricing of
financial options. However I need a column for the value of N(x) which using
polynomial approximation gives the probability that a normally distributed
variable with a mean of zero and a standard deviation of 1 is less than x. Is
this a possible function on EXCEL and if so how do i use it?

 

[Dav]

Try NORMSDIST, but in the value and it gives you the cumulative
probability

Regards

Dav