Author: Oscar Cronquist Article last updated on May 11, 2022

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

Formula in cell C3:

=PHI(B3)

Excel Function Syntax

PHI(x)

Arguments

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

Comments

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.