How to use PHI Function in Excel

The PHI function returns the value of the density function for a standard normal distribution.

Syntax:= PHI(x)

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.

Example: Let’s look at some Excel PHI function examples and explore how to use the PHI function as a worksheet function in Microsoft Excel:

Syntax:  =PHI(A2)

Result: 0.301137432

Based on the Excel spreadsheet above, the following PHI examples would return:

Note:

1. #VALUE! error – Occurs when x uses a data type that is not valid, such as a non-numeric value.
2. #NUM! error – Occurs when x is a numeric value that is not valid.