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:

Syntax: =PHI(A3)
Result: 0.129517596

Syntax: =PHI(A4)
Result: 0.053990967

Syntax: =PHI(A5)
Result: 0.396952547

Syntax: =PHI(A6)
Result: 0.241970725

Syntax: =PHI(A7)
Result: 0.053990967

Syntax: =PHI(A8)
Result: 0.352065327

Syntax: =PHI(A9)
Result: 0.129517596

Syntax: =PHI(A10)
Result: 0.0175283

Syntax: =PHI(A11)
Result: 0.004431848


  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.


Add a Comment

Your email address will not be published. Required fields are marked *