PHI function

The PHI function returns the value of the density function for a normal distribution with mean 0 and standard deviation 1, calculated with the formula .

Parts of a PHI function


Parts Description
x The input to the standard normal distribution function.

Sample formula



This is a special case of the NORMDIST function, where mean is 0, standard deviation is 1, and 'cumulative' is false.


  A B
1 Formula Result
2 =PHI(0.5) 0.3520653268
3 =PHI(1) 0.2419707245
4 =PHI(1.5) 0.1295175957

Related functions

  • STDEV: The STDEV function calculates the standard deviation based on a sample.
  • NORMDIST: The NORMDIST function returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.
Was this article helpful?
How can we improve it?