How can I download and install ERROR FUNCTION in Excel 2003? ERF.
How can I download and install ERROR FUNCTION in Excel 2003? ERF() is not
available in my excel. Thanks much! |
Do you have the Analysis Toolpak installed?
-- Vasant "Zhiming Qi" <Zhiming wrote in message ... How can I download and install ERROR FUNCTION in Excel 2003? ERF() is not available in my excel. Thanks much! |
As an alternative to installing the Analysis ToolPak, you could use
Erf(x) = GammaDist(x^2,0.5,1,TRUE) ErfC(x) = ChiDist(2*x^2,1) = 2*NormSDist(-x*Sqrt(2)) ChiDist is more accurate than ErfC in all Excel versions. In Excel 2003, NormSDist is more accurate that either ErfC or ChiDist. Jerry Zhiming Qi wrote: How can I download and install ERROR FUNCTION in Excel 2003? ERF() is not available in my excel. Thanks much! |
All times are GMT +1. The time now is 10:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com