Polynomial approximation
 

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?

Polynomial approximation
 

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

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=519367