This article describes the formula syntax and usage of the PHI function in Microsoft Excel.
Returns the value of the density function for a standard normal distribution.
The PHI function syntax has the following arguments.
- X Required. X is the number for which you want the density of the standard normal distribution.
- If x is a numeric value that is not valid, PHI returns the #NUM! error value.
- If x is using a data type that is not valid, such as a nonnumeric value, PHI returns the #VALUE! error value.
The workbook below shows examples of this function. Inspect them, change existing formulas, or enter your own formulas to learn how the function works.
To work more in-depth with the example data in Excel, download the embedded workbook to your computer, and then open it in Excel.
Top of Page