Author: Oscar Cronquist Article last updated on August 06, 2018

The PHI function calculates a number of the density function for a standard normal distribution.

Formula in cell C3:


Excel Function Syntax



x Required. x is the number for which you want to calculate the density of the standard normal distribution.


The PHI function returns:

  • #NUM# error value if the argument is an invalid numeric value.
  • #VALUE! error value if the argument is an invalid data type, like a non numeric value.

The following chart shows the density values for a normal distribution where x is between -4 and 4.