I have harped on for over 2 years, but finally Microsoft has fixed a bug in Excel.
When using the new statistics functions in a Named Formula like where:
x is a named formula of values between 0 and 20 in steps of 0.5
mean = 10
sd = 2.5
Y: =NORM.DIST(x,mean,sd,FALSE)
Used to cause Excel to Crash
The last time I checked in Feb 2012, when 2013 was released it was still a problem, but today it is fixed.
I update regularly so I'm not sure exactly when it arrived
So Well Done Microsoft
Hui...
When using the new statistics functions in a Named Formula like where:
x is a named formula of values between 0 and 20 in steps of 0.5
mean = 10
sd = 2.5
Y: =NORM.DIST(x,mean,sd,FALSE)
Used to cause Excel to Crash
The last time I checked in Feb 2012, when 2013 was released it was still a problem, but today it is fixed.
I update regularly so I'm not sure exactly when it arrived
So Well Done Microsoft
Hui...