An Excel 2003 formula returns the #NUM! error flag when the formula uses the NORMDIST and NORMSDIST function

A Microsoft Office Excel 2003 formula may contain the statistical function NORMDIST. Additionally, the absolute value of (X-mean) for this function may have a value that is equal to or greater than 3,221,225,552. In this case, the formula returns the following error flag:
A Microsoft Office Excel 2003 formula may contain the statistical function NORMSDIST. Additionally, the absolute value of z for this function may have a value that is equal to or greater than 2,147,483,648. In this case, the formula returns the following error flag:

This problem was first fixed in a hotfix that is now contained in the latest service pack for Microsoft Office 2003. If you have already installed the latest service pack for Office 2003, you do not have to reinstall it. However, you do have to set the registry key and activate the hotfix that is included in the service pack. To do this, go to the "How to enable this hotfix" section.

If you have not installed either the latest service pack for Office 2003 or the hotfix, you should install the latest service pack for Office 2003 if you can. If you cannot install the latest service pack for Office 2003 for some reason, you should install this hotfix. After you install the service pack or the hotfix, you have to set the registry key and activate the hotfix. To do this, go to the "How to enable this hotfix" section.

How to obtain the latest service pack for Office 2003

This problem is corrected in Office 2003 Service Pack 3. To resolve this problem, obtain the latest service pack for Office 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
After you install the service pack, follow the steps that are listed in the "How to enable this hotfix" section.

How to obtain the hotfix

This issue is fixed in the Excel 2003 post-Service Pack 2 hotfix package Hotfix Package that is dated October 2, 2006. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
After you install the hotfix, follow the steps that are listed in the "How to enable this hotfix" section.

To have us set the registry key and to activate the hotfix for you, go to the "Fix it for me" section. If you would rather do this yourself, go to the "Let me fix it myself" section.

To set the registry key and to activate the hotfix automatically, click the Fix this problem link. Then, click Run in the File Download dialog box, and follow the steps in this wizard.




Note this wizard may be in English only; however, the automatic fix also works for other language versions of Windows.

Note if you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.

Now go to the "Did this fix the problem?" section.

Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

1. Exit Excel 2003.
2. Click Start, click Run, type regedit, and then click OK.
3. Locate and then click the following registry subkey:
   HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options\
4. After you select the subkey that is specified in step 3, point to New on the Edit menu, and then click DWORD Value.
5. Type NORMDISTFix, and then press ENTER.
6. Right-click NORMDISTFix, and then click Modify.
7. In the Value data box, type 1, and then click OK.
8. On the File menu, click Exit to exit Registry Editor.

Now go to the "Did this fix the problem?" section.

Check whether the problem is fixed. If it is fixed, you are finished with this article. If it is not fixed, you can contact support.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.This problem was first corrected in Office 2003 Service Pack 3.